Synching information to/from Windows Mobile 2003 Device

[John]

Hi

We have an access db which records daily orders. We would like the orders to
be downloaded to a windows mobile 2003 device via usb cradle. Drivers then
take along the device and get signatures from customers when items
delivered. Once drivers are back, the information to be synched back to the
access db as drivers may have amended the order detail.

How does one go about synching to/from mobile device? Are there any code
examples around?

Thanks

Regards

[Darryl Kerkeslager]

With SQL Server, there is software that synchs your mobile device directly
with SQL Server, SQL Server CE at
http://www.microsoft.com/sql/CE/default.asp

However, with Access, your choices are less perfect. Pocket Access is
nothing more than the database storage, with no provided means to get to the
data - Pocket Jet might have been a better name.

You can easily export Access data into html format, which can then be
displayed in IE on the PDA. This is what I currently do, however, there is
no way to get data into the PDA using standard IE. I tried using xml, which
worked fine with Windows CE 2000, however, the newest version of Windows
Mobile, 2003, introduced a bug that does not allow XML to be displayed (at
all) using XSL.

Visual CE looks like a promising development langage for databases, but I've
not tried it:
http://www.syware.com/about/about.htm

Here is an article on using embedded Visual Basic with ADOCE, which is ADO
for Windows CE, but is not an MS product, and is not cheap.

http://www.devbuzz.com/content/zinc_...tabase_pg2.asp

There are lots of Windows CE databases springing up; I've looked at a lot of
them, but haven't decided on one yet. Here are some of the more highly
regarded:

http://www.biomobility.com/dotr4.htm

http://www.handmark.com/products/detail.php?id=74

http://www.kaione.com/Product_Info/product_info.html

Also, Grandasoft has an interesting product.
Darryl Kerkeslager
"John" <Jo**@nospam.infovis.co.uk> wrote:

Hi

We have an access db which records daily orders. We would like the orders to be downloaded to a windows mobile 2003 device via usb cradle. Drivers then
take along the device and get signatures from customers when items
delivered. Once drivers are back, the information to be synched back to the access db as drivers may have amended the order detail.

How does one go about synching to/from mobile device? Are there any code
examples around?

Thanks

Regards