sql server replication: Users use a inhouse app with Access 2000 backend. This isn't going to change,
however the data in the Access file needs to sync nightly with a SQL database
on a different server.

Whats available to complete this task?

You could use replication (see Hilary's free chapter for details of setting
this up: http://www.nwsu.com/lowres_replication_ch02.pdf) or you could use
DTS. Replication will have the advantage of syncing data originating from
the publisher or the subscriber, while this ends up being very problemattic
using DTS. If you just want to push data in one direction though, DTS could
be used.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

create a merge publication on SQL Server to the access database. When the
merge agent runs it will upload the changes from access to sql server.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]