Synchronising with remote server

25 Dec 2005 1:01 AM

John

Hi

We have an internal ms access database which we need to synchronise with our
website with sql server 2005 backend which is hosted on a public host. My
question is; is there a way to keep the two databases synchronised using the
technologies built in sql server 2005 and/or access? We also have the
possibility of an in-house sql server 2000. Can this be used in anyway to
help, perhaps by moving data from in house access to in house sql server
2000 and then synching sql server 2000 and remote sql server 2005?

Thanks

Regards

25 Dec 2005 2:23 AM

Hilary Cotter

There is no canned solution for replication over the internet between SQL
Server and Access. You can replicate between SQL Servers or between Access
databases over the internet but not the two of them.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Show quote

"John" <John@nospam.infovis.co.uk> wrote in message
news:%23eE3y6OCGHA.1032@TK2MSFTNGP11.phx.gbl...
> Hi
>
> We have an internal ms access database which we need to synchronise with
> our website with sql server 2005 backend which is hosted on a public host.
> My question is; is there a way to keep the two databases synchronised
> using the technologies built in sql server 2005 and/or access? We also
> have the possibility of an in-house sql server 2000. Can this be used in
> anyway to help, perhaps by moving data from in house access to in house
> sql server 2000 and then synching sql server 2000 and remote sql server
> 2005?
>
> Thanks
>
> Regards
>