如何让同一服务器上的SQL2000和ACCESS7中数据库部分资料保持同步？.txt

USE SQL SERVER Jobs!
Command:
INSERT INTO [TableOfSQL] ([ID],[F1],[F2],[F3])
SELECT [ID],[F1],[F2],[F3]
FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=\..\XXX.mdb')...[TableOfAccess] AS T1
WHERE [T1].[ID] NOT IN (SELECT [ID] FROM [TableOfSQL]

使用Replication
把SQL Server 作用發布端，Access97作用訂閱端，采用合并複制