Hi,

I'm new to the mobile era. I have an application running on desktops. I'm using VS 2003 and Access database. I want to make my application work on pocket pc. Till I can communicate with my desktop application through tcp/ip, but can't find a way to connect to my ACCESS database. In my app I used either oledb or adodb.recordset to connect to DB. but here i found none of them. I need suggestion from you how should I move forward. I have several things in mind -

1. find a way out to use existing Access DB
2. Use TCP/IP request to the server and let server do all the tasks
3. Convert the whole app with DB in sql server, so that I can use SQLServerCE.

for 1, as far I found, there is a tool called ActiveSync, which synchronize the dbs in desktop and pocket pc (cdb to mdb and viceversa). Won't it be a slow process. I mean everytime i made a change in the db I have to synchronize the whole db in all clients.

If I can't get through 1 I'll use 2. But stuck with the thought that it might be better to move to sql server now before I have to. Before that I need to know if i use sqlserverce will it be possible to connect to sqlserver 2000 (on desktop) directly or will I be required to go with the synchronization process again.

Thank you in advance

shomoodro