Synchronising/replicating access with sql server

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 registe
r
an Access DB as a replication Subscriber using Enterprise Manager
(http://msdn.microsoft.com/library/d...br />
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/d...br />
11bn.asp).
For infomation on other issues to watch out for, see
http://msdn.microsoft.com/library/d...br />
1bn.asp.

Best wishes,

--
Glenn Gailey

SQL Server User Education

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


"John" wrote:

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