sql server/adp sync local copy

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
have you tried microsoft.public.access.replication?


JP said:
i have a sql server (2000) database, on a windows server 2000 network and
Click to expand...
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
Click to expand...
controls but could anyone point me in the direction of a good descriptive
article or tell me a different direction i could take.
 
Back
Top