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