We have an Access 2010 database inventory system. We need to build an app for a Motorola smart device (scanner) that the users can take offsite to use at other locations.
We would like to download a subset of the Access database data to the smart device and use it as data for an app running on Windows Mobile 6. Users will then take the smart device to other remote sites and scan or data entry. When they return to the main office, the data needs to be uploaded and re-synched to the Access database.
I spent hours today figuring out that Visual Studio 2010 doesn't support development for Windows Mobile 6.0. In fact, two Microsoft customer support staff told me it would until I proved them wrong.
From what I understand (please correct if wrong), you cannot run Access 2010 on Windows Mobile 6.
Would you recommend building an app using Visual Studio 2008 to download to the smart device?
What format would the data need to be on the smart device such that it can be downloaded from Access, used by Mobile 6 and resynched with Access 2010?
I would prefer a web-based system but we're concerned about performance (data entry speed) and if some remote locations don't have good internet connection.
Any suggestions are much appreciated.