• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Managing a Database > Replicating a Database

Replicating a Database

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

If necessary, remove the database password from the database.

Open the database in exclusive mode. In the Open dialog box, click the Open button list arrow, and then click Open Exclusive.

Click the Tools menu, point to Replication, and then click Create Replica.

Click Yes to close the database.

If necessary, click Yes to make a backup copy of the database.

Enter the name for the replica.

Specify the location where you want to save the replica.

Click OK.

Click OK to confirm the creation of the Design Master and the replica.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint