sql server new users: 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,

--
Glenn Gailey

SQL Server User Education

This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]