Best way to sync SQLServer DB with multiple Access DBs?

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am building a client server solution, with SQL Server 2000 at the
heart. I have a VB.Net client that is based on Access db as it is
required to be disconnected on a laptop most of the time. When the
user reconnects, I need the data in the laptops Access db to be sent
to the SQL server and any new data in the SQL server db to be
downloaded to the local access db..

1. Should I be using SQLXML 3.0 to do this.
2. Anybody have any sample code of how to do this?
3. Is this the best method for syncing data?
4. Is there a licensing issue with using an Access database?

Thanks for any help.

Regards
John
 
Hi,

A more practical solution would be to use MSDE instead of access
(replication).

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

I am building a client server solution, with SQL Server 2000 at the
heart. I have a VB.Net client that is based on Access db as it is
required to be disconnected on a laptop most of the time. When the
user reconnects, I need the data in the laptops Access db to be sent
to the SQL server and any new data in the SQL server db to be
downloaded to the local access db..

1. Should I be using SQLXML 3.0 to do this.
2. Anybody have any sample code of how to do this?
3. Is this the best method for syncing data?
4. Is there a licensing issue with using an Access database?

Thanks for any help.

Regards
John



----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
Click to expand...
=---
 
Back
Top