Post by Davi » Thu, 16 Feb 2006 19:04:39

New here. I am trying to put an Access database on my mobile device running
Windows mobile 5 and Activesync 4.1
Does anybody know how to do this?
Ho do I find Pocket Access?
Or any third party software to do it?


David Luddington


Post by Raj Pilla » Fri, 17 Feb 2006 00:33:40

Hi David,

The support for ADOCE was dropped in Windows Mobile 5. Therefore you will
not be able to convert the MS Access database files as in earlier versions.
At the moment I am unaware of any third party software which will work with
WM 5.0 to do the same.

Raj Pillai
Microsoft MVP - Mobile Devices



Post by Chris Jord » Fri, 17 Feb 2006 19:45:44

Why would Microsoft drop support for Access and ADOCE??
Presumably they had a better product in the wings....



Post by Sven » Sat, 18 Feb 2006 10:20:11

ADOCE was the db engine being used at one time.. Support for it was dropped
some time ago and developers were made aware of it's impending demise. The
conduit in ActiveSync was there to support Pocket Access which was only
available on the handheld PC platform. There never was Pocket Access for
Pocket PCs. AS 3.8 still supports the Access conduit and AS 4.1 still does
if a pre-WM5 device is connected. Since there is no Pocket Access in WM5
(never was as I pointed out) there is no need for MS to develop an Access
conduit in AS 4.1 for connection to WM5 devices. AS 4.x was a total rewrite.
I don't like it either, but that's the deal.

There is SQLCE or SQL Mobile that can be used as a DB on the mobile
platform. Don't ask me how, I haven't messed with it. It also is designed to
work with SQL Server, which likely not installed at everyone's home. There
is unfortunately no current method to sync Access DBs on the desktop into
.cdbs on WM5 handhelds. That may or may not change. If it does that helps a
lot, as things like SprintDB and DataOnTheRun do work on WM5 if you can get
a .cdb onto the device. You can create a new one, but I suspect most are
wanting the data the have on their PC in Access at least transferred, if not
sync'd. This would be a temporary solution at best as ADOCE support has been
dropped. What that means is that if ADOCE components have a problem, it's
not getting addressed.

Hopefully what will happen is that an Access to SQL Mobile conduit will be
created (by someone), and the developers will provide some nifty tools to
work with the SQL Mobile data on the PPC.

Until then, HandBase is an option.

MVP - Mobile Devices


Post by Davi » Sat, 18 Feb 2006 17:37:50

Thanks Raj and Sven

Guess I'll have to wait a while or try to create a database in Excel!!!

David Luddington