By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,909 Members | 2,008 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,909 IT Pros & Developers. It's quick & easy.

Synchronising with remote server

P: n/a
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

Dec 25 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi John

You may want to consider using replication, you may also want to consider
moving from Access to SQL Server 2005 Express and just using Access as the
front end.

John

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:T7********************@pipex.net...
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

Dec 25 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.