Share this Page URL
Help

Chapter 18. Maintaining an Access Database > Synchronizing Replicas - Pg. 637

Maintaining an Access Database 637 5. The original database has been designated as the Design Master, and you can make changes to the design of database objects only in the Design Master. Click OK in the message box, and you'll see the Database window, shown here. The database objects now include an icon indicating that they can be replicated. When you create a new table or query in the Design Master, the Save As dialog box will include an option named Make Replicable. If you don't select this option, the object won't be included when you synchronize replicas in the replica set. Synchronizing Replicas As mentioned earlier, within a replica set, you can make changes to the design of database objects only in the Design Master. Database users can update data in the Design Master as well as in any of the other databases in the replica set. Design and data changes made in the Design Master and updates to data made in the replicas then need to be synchronized so that each replica in the set has available the same set of data and the same database objects. Before you can synchronize a replica, all database objects in the database must be closed. In the following steps, we'll demonstrate the process of synchronizing replicated databases.