Hi

Is there a way to synchronise/replicate an access db with sql server 2000
db, short of writing the code oneself?

Thanks

Regards

John, SQL Server 2000 supports Access (JET 4.0) Subscribers. You can register
an Access DB as a replication Subscriber using Enterprise Manager
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replhet_11bn.asp)
and then create a subscription to a SQL Server Publication for the Access
Subscriber. Make sure that the publication supports non-SQL Subscribers
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replhet_11bn.asp).
For infomation on other issues to watch out for, see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replhet_11bn.asp.

Best wishes,

Show quoteHide quote

DBCC CHECKIDENT call never returns
Problem with Maintenance Plan to delete files older than 2 days
Activity Monitor: SQL 2005
SQL Server Management Studio - mscorlib.tlb could not be loaded
SQL Management Studio keeps giving errors