Microsoft Access

[sdr2d2]

I want to convert a microsoft access database so that I can view it on the psion. I do not need to update or modify the database jsut view.

When I tried to convert it to a data file psiwin said that access is denied. What does this mean?

Is there any software I can download that will alow me to do this or perhaps another method? Such as converting the database to a different file type?

Btw the database uses relationships and ideally would like these to still work...

Cheers for any help, Sam D:confused:

[Jim Cooke]

Sam,

You have two issues here. The first the inabaility of PsiWin to convert the Access database. If this is a releational database then that means it has several tables. PsiWin cannot convert a multitable database. In general, PsiWin is incapable of converting even simple databases. I get the "Access Denied" error al' the time even with databases that have only two fields if the file size is too large.

You can convert a single table to CSV format and then copy that file to your Psion and import the data into a new Data after you have set up the field names to match exactly the field names and physical order of the Access CSV file.

I've found that PsiDat by Kevin Millican is a much better database program than Data. You can have subtables and indexes and create some fairly complex relational databases. Best of all, it's free. You can download a copy at http://www.millican.info/Home/PsiDat.htm . If you already understand Access relational databases and SQL, I think you'll find this is a much better match for your needs than Data.

Regards, Jim

[sdr2d2]

Thanks for your help.

Is PsiDat compatible with Microsoft Access?

Sam

[Jim Cooke]

Sam,

I suggest that you read the description of PsiDat at Kevin's homepage. PsiDat is not directly compatible with Access in that you can't just drag and drop an Access database into PsiDat. You can use dBase exports from Access to recreate tables, memos, and indexes that can then be reconstructed in PsiDat. While PsiDat doesn't have all the power of Access, it's about the most complete relational database I know of on any handheld platform. In addition, the price is very reasonable. ;)

Regards, Jim