Discussion Locked

Access replication over internet

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to set up a database that will be used by 5 offices. I want to have the design master at our headquarters, with replicas at the other 4 offices. Every office but one has DSL. What is the best way to keep these databases synchronized witheach other? It only needs to synchronize during the night because I realize we don't have a good enough connection for a real-time database. What is the best solution for this project? Thanks in advance...

Casey

5 replies

by mckaytech

The easiest and best-supported way to do this appears to be to use an Access2000 database and the Office2000 Developer Edition.

With this combination, the underlying database engine is Jet v4.0 and you can use the Microsoft Replication Manager (included with Office2000 Developer)to configure and schedule the database replications to occur automatically at scheduled intervals.

Microsoft has an article on TechNet (Q190766) that lists the replication white papers related to the Jet v4.0 database.

It sounds like an interesting project...

paul

by Former member

it sounds more like a nightmare. WHo will be writing to the database? Will there be 4 read-only copies and one to where they can write (Master DB)? If not, then you have a serious problem. Otherwise, have only one database and upgrade the WAN links.We also have a similar situation: One Master SQL Database, here at HQ, 13 remote sites throughout the state. T1 links to all sites. BUT, we used to have 56K frame-relay until I upgraded, but it worked fine even over the 56K.

Good luck!

This discussion is closed to new replies.