Creating a Replica Set

When you create a new replica set, the database you convert becomes the Design Master. You can have only one Design Master in a replica set. Any changes to the design of the database, or to the design any of the replicable tables, queries, forms, reports, macros, and modules in the database can be made only in the Design Master. This prevents users at multiple replicas from making conflicting changes to the database’s design and objects. You can still make changes to local (nonreplicable) objects in a non-Design Master replica, but those changes will remain local to the replica in which they were made.

You can convert your database from a nonreplicable form to a replicable form in one of four ways:

• Using the Create Replica command in Microsoft Access
  
  
• Dragging the database file to the My Briefcase icon
  
  
• Using the Convert Database To Design Master command in Microsoft Replication Manager
  
  
• Using DAO code

This section describes how to convert your database by using DAO code.