Access Database For PDA's

[Groundrush]

Has anyone here used Access on a PDA yet?

I'm looking into the possibilities of creating a db to be used on a PDA for people to instantly update records, and then possibly download the data onto a pc to update the main db.

Any suggestions?


thanks

 

[Groundrush]

Or any suggestions on a good PDA to use that is compatible with Access

thanks.

 

[John.Woody]

I use DB Anywhere on my ipaq hx4700. You can convert your access BE to mobile access format and build a new FE for your pda in DB Anywhere. It doesn't support autonumber though so I converted my autonumber field to number and generate my own numbers both on the PC and the PDA. Microsoft active sync syncronises the db updating from the PDA to the PC or PC to PDA according to what you have done. It even amends a record if its changed. I've only done fairly simple dbs using 2 - 3 tables but it works for me
http://www.pocketgear.com/software_detail.asp?id=1190

 

[Groundrush]

Thanks..