|
Home > Archive > MS SQL Server > December 2005 > Synchronising/replicating access with sql server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Glenn Gailey [MS] 2005-12-30, 8:23 pm |
| 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/d...eplhet_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...eplhet_11bn.asp).
For infomation on other issues to watch out for, see
http://msdn.microsoft.com/library/d...plhet_11bn.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
>
>
>
>
|
|
|
|
|