Tuesday, July 29, 2014

How To Replicating a Database in Access 2003

In some multi-user environments, users are scattered over a wide area, making it impossible for them to use the same database file. One method of providing access for these users is by replicating the database. The original database becomes the Design Master, and the other database files are replicas. You can add records to any of the database files, but you can only make structural changes (such as adding tables) to the Design Master. Periodically, you should synchronize each replica with the Design Master. This ensures that each file has the most current data and database design. If a conflict arises between the values entered in the databases, you can choose which values are correct.

Create a Replica

graphics/1_icon.jpg
If necessary, remove the database password from the database.
graphics/2_icon.jpg
Open the database in exclusive mode. In the Open dialog box, click the Open button list arrow, and then click Open Exclusive.
graphics/3_icon.jpg
Click the Tools menu, point to Replication, and then click Create Replica.
graphics/4_icon.jpg
Click Yes to close the database.
graphics/5_icon.jpg
If necessary, click Yes to make a backup copy of the database.
graphics/6_icon.jpg
Enter the name for the replica.
graphics/7_icon.jpg
Specify the location where you want to save the replica.
graphics/8_icon.jpg
Click OK.
graphics/9_icon.jpg
Click OK to confirm the creation of the Design Master and the replica.
graphics/12inf11.jpg

Update a Replica

graphics/1_icon.jpg
Open the replica you want to update.
graphics/2_icon.jpg
Click the Tools menu, point to Replication, and then click Synchronize Now.
graphics/3_icon.jpg
Click the Directly With Replica option.
graphics/4_icon.jpg
Enter the name and location of the Design Master, if necessary.
graphics/5_icon.jpg
Click OK.
graphics/6_icon.jpg
Click Yes to close and re-open the replica.
graphics/12inf12.jpg

Did You Know?

You can resolve replication conflict. Open the Design Master or the replica you want to check for conflicts, click the Tools menu, point to Replication, and then click Resolve Conflicts. If there's a conflict, click View, resolve the conflict, and then click OK.
You can replicate a database instead of sharing one copy over a network. Replication helps to reduce network traffic because not everyone uses the same copy. You can also back up the Design Master while other users continue to work on their replicas.
More about the Design Master. The Design Master is a database to which system tables, fields, and replication properties are added. Only one Design Master exists per replica set.