Synchronized 2 or more database

[Moore71]

Hi,
I am just thinking how i can implement 2 or more database to synchronize automatically every 5 minutes such that when databases exists, old ones should be deleted while new ones should be synchronized and if path does not exist, users should be prompted for new path.

Thank you for your contributions

Moore

 

[llkhoutx]

It's not clear to me what you mean by "synchronize."

 

[Moore71]

I mean to update the databases on different laptops, desktops and other devices as are connected to the main server on a Local Network, not internet.
Such that every changes made by different users will be synchronized to one another

Thank you

 

[jdraw]

Are these laptops connected in any way --LAN?
Please tell us more about the business requirement in plain English. The post is not clear as llkhoutx has said.

Keeping multiple laptops/computers current is the rationale for many online databases/applications.

 

[Moore71]

Yes and No
Yes because the connections are through LAN, but No because they are always on field work, so they only connect when they are in the office to use the LAN, then they update their records and the various changes will be effected in every devices

 

[llkhoutx]

I have done this before using the following method:
1. Add a table to the back end whose records indicate a unique version number, a reason for the revision, and a date created. This gives a list of all changes.
2. Add a similar, but single, record to the (distributable) front end database on a shared drive.
3. Update the both the (master) front end and back end tables with a new revision number, each time the the (master) front end is updated and is available for distribution.
4. When each front end is first opened, compare the last version number of the front end and back end. If they do not match, display a message advising that the front end should be updated with the most current version on the shared drive.

Note that all updates may or may not be critical for every user.

Good luck.