sql server/adp sync local copy

[Guest]

i have a sql server (2000) database, on a windows server 2000 network and access data project (access 2000) front end on clients. Is it possible to create a local copy of the database that workers with laptops can take away, complete some work, and synchronise with sql server when they next connect to the network (in the office or VPN)
i have read a little about the SQLMerge and SQLDistribution ActiveX controls but could anyone point me in the direction of a good descriptive article or tell me a different direction i could take
Any advice is greatly appreciated
Thanks

 

[solex]

have you tried microsoft.public.access.replication?

i have a sql server (2000) database, on a windows server 2000 network and

access data project (access 2000) front end on clients. Is it possible to
create a local copy of the database that workers with laptops can take away,
complete some work, and synchronise with sql server when they next connect
to the network (in the office or VPN).

i have read a little about the SQLMerge and SQLDistribution ActiveX

controls but could anyone point me in the direction of a good descriptive
article or tell me a different direction i could take.