I have a report that I have created with Access and I want to be able to use a PDA or smartphone device for data entry but I am having trouble finding information on doing this. Is there a mobile version of Access?

2/28/2008 6:25:55 PM

pretty sure there is

[Edited on February 28, 2008 at 6:41 PM. Reason : nvm, a quick google search says they didnt include access and powerpoint]

2/28/2008 6:40:55 PM

Most of the data entry via pda I've seen is done with oracle not access. I have seen people with mobile mysql admin tools on their PDA though.

[Edited on February 28, 2008 at 6:58 PM. Reason : ]

2/28/2008 6:57:36 PM

You can use excel on your PDA and push it to access on sync pretty easily.

2/28/2008 7:21:13 PM

what's the OS on the device - if it's windows mobile then which version

2/28/2008 8:26:33 PM

Windows Mobile 5.0 dropped support for ADOCE so you will not be able to use Pocket Access there. If it is Pocket PC 2003 or earlier than you can use ActiveSync to convert the .mbd to .cdb and synchronize with the handheld. Microsoft is pushing people towards the SQL Server Mobile\Compact Edition line as a replacement.

Here are the MSDN forums for SQL Server CE:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

Look into using XML, I bet it will fit most of your needs and it is easily integrated into .NET DataSets for pushing to a DB when needed.

2/28/2008 10:06:52 PM