Replication between SQL Server 2000 and MS Access 2000.

[dealwi8me]

Is it possible to have the master datebase in SQL Server, the replica in Access format and still can sychronize them?

Thank you in advance.

 

[boblarson]

I don't think so, but you can use MSDE (or now known as SQL Server Express) to use as the replicated db on the client.

 

[dealwi8me]

I'm not sure if i am allowed to install MSDE to the computer so i will try the replication through access (master and replica).

Thank you

 

[dfenton]

Is it possible to have the master datebase in SQL Server, the replica in Access format and still can sychronize them?

Yes. It's called HETEROGENOUS REPLICATION and it was first introduced with SQL Server 2000 and Access 2000. The documentation for how it works is in the SQL Server documents on MSDN.

--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/