sql server msde: Setting up replication with access front end -- sql server msde

Setting up replication with access front end

John
4/26/2005 12:00:00 AM

sql server msde: Hi

We have an access app (front-end+backend) running on the company network. I
am trying to setup replication for laptop users who go into field and need
the data synched between their laptops and the server upon return to the
office. I am planning it this;

Move all access tables to sql server and then link the tables to access
front-end mdb app (using odbc?). Copy the same setup (access front end + sql
backend) onto each laptop. Setup replication between the server sql server &
each laptop's sql server. My question is; would this sort of setup work? Is
there a better way to do this?

Thanks

Regards

Re: Setting up replication with access front end

Alex White MCDBA MCSE
4/26/2005 12:00:00 AM

Hi John,

you are on the right track, on the laptops use the MSDE version of SQL use
full SQL on the server, use merge replication as the replication topology,
be warned, get your data structures near perfect before replicating, because
simple field changes later on can be complicated because of the replication
system.

Hope it helps.

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

[quoted text, click to view]