.NET db access (Access to sql)

[sporkster]

Hello all,

I have a desktop application that uses an access database, and I need to have access to it on the mobile device. How can I get sqlce to open the access database?

--> using VB.NET 2005 / Windows Mobile 6


Thanks in advance

[Shaggy Hiker]

I have a mobile app that is used to enter data onto a SQL Server CE database, then sync with an Access database on a laptop. That's not necessarily all that close to what you are doing, but perhaps it applies. The technique I used was to open a TCP connection and pass the tables using XML. Much of the code for that has been posted on this forum, but it was over a year ago (in fact, it has been about two years since I even worked on that project, so even my memory is dated on the subject).

If that sounds like it might be of interest, you can search on my username and something like TCPListener in this forum, and you'll find the threads. Of course, that's not having "sqlce open the access database", that's more a case of the access database getting packaged up and sent to the mobile.

[petevick]

Hi,
we have an application, SqlLinkCE that does that, and there are other 3rd party sollutions.

There is also an access to SqlCe synchronise, provided free from Microsoft