all groups > sql server new users > april 2005 >
You're in the

sql server new users

group:

Setting up replication



Setting up replication John
4/24/2005 12:00:00 AM
sql server new users: Hi

I have just converted an access mdb app to an access adp app with msde
backend. I am very new to sql server. My question is how do I create
replication for a few laptop users who would like to take away the app for a
few days and when they come back would like all the new data (laptop &
server) to sync with each other? I presume I need to have msde on each
laptop and then copy the access app and the data on each laptop. What do I
do from there?

Thanks

Regards

Re: Setting up replication Tom Moreau
4/24/2005 6:15:01 PM
It looks like you need to create a merge publication within MSDE, with the
Access databases as subscribers. These should be Push subscriptions.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
[quoted text, click to view]
Hi

I have just converted an access mdb app to an access adp app with msde
backend. I am very new to sql server. My question is how do I create
replication for a few laptop users who would like to take away the app for a
few days and when they come back would like all the new data (laptop &
server) to sync with each other? I presume I need to have msde on each
laptop and then copy the access app and the data on each laptop. What do I
do from there?

Thanks

Regards

AddThis Social Bookmark Button