472,325 Members | 1,500 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,325 software developers and data experts.

Synchronising with remote server

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
1 1328
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: justme | last post by:
Dears I have created the following page to display my data <head> <style type="text/css"> body, td, th, h1, h2 {font-family: sans-serif;}...
6
by: paulus4605 | last post by:
Dears I have the following problem Iím using a query to get all the data from my database from the past year the second query is displaying...
1
by: judy | last post by:
I have a number of Acess databases on a web site and copies of these databases on my local PC. The databases can be independently updated on the...
1
by: Michael Thomas | last post by:
Hi everyone Having a slight problem synchronising tables in MS Access 2002. I have two tables: Products (StockCode*, Description, CostPrice,...
1
by: Rajesh Sharma | last post by:
Dear all, please help me in Combo Box Synchronising. I have three levels. Category -> Type -> Subtype Depending on the selected Category,...
1
by: John | last post by:
Hi Is it possible/feasible to have two-way replication (synchronisation) between an access database and a sql server 2005 database? I am just...
4
by: John | last post by:
Hi Is there a way to synchronise/replicate an access db with sql server 2000 db, short of writing the code oneself? Thanks Regards
0
by: adamjc | last post by:
Hi, I need to develop a program to synchronise tables in a local Access database with tables in a replica Access database on a central web server. Is...
3
by: chromis | last post by:
Hi, I've just setup a development server for testing websites at my office and wish to synchronise it with the sites folder on our live server,...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.