Networks

Ask something
Question Locked

How to synchronize access databases ?

0 helpful
3 replies

by ghassanmuthanna

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

The scenario is like follow:
I have one access database in a server, but for some reasons, I needed to make tow other copies of this DB?
So now I have three copies of this DB?
Each copy of the DB will be located in different server in different location in different city ( the locations connected to each other as LAN)?
So any update to any one of the DBs must be replicated to other DBs to be up to date and synchronized?
The replication process will begin each day overnight..
This process need to be automatically?
So, I need to synchronize the DBs with each other, I need to know the steps to make this process, if you have an idea about this issue or any help reference...
So, I will be truly yours

3 replies

by robo_dev

Keep your data in sync with Access database replication

http://articles.techrepublic.com.com/5100-10878_11-6154732.html

HOWEVER:
Microsoft Access has frequent integrity issues when running on a single stand-alone PC, so doing replication across multiple servers would be a bad, bad, bad idea.

Use a database such as MS-SQL, Oracle, or even Sybase, but not Access.

by tony hopkinson

Even MySQl, anything but Access. Huge tin of worms.
If you are really lucky when the access mdb corrupts, replication will fail.

This discussion is closed to new replies.