Synchronising with remote server

[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

 

[David W. Fenton]

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?

I've been reading this newsgroup for many years and there are hardly
any posts in it about heterogeneous replication. 99% of the
expertise here is about Jet-only replication. I'd suggest posting
your question in an appropriate SQL Server newsgroup(s).