Replicating Your Database

The first step in making your database replicable is to create a Design Master. You can create a Design Master by using any of the methods discussed in the “Implementing Database Replication” section earlier in this chapter.

After you have created the Design Master, identify the objects in the database you don’t want replicated. In Microsoft Access, you can keep an object from being replicated by clearing the Make Replicable check box in the Save As dialog box when you save an object in the Design Master. You can also convert a local object to a replicable object by right-clicking the object in the Database window, clicking Properties on the shortcut menu, and then selecting the Replicable check box. All objects saved in a replica (not the Design Master) will automatically be local, nonreplicable objects.

To create local objects programmatically, set their KeepLocal property to the string value “T” (the quotation marks are part of the string). You can only set the KeepLocal property of database objects before you create the Design Master. The KeepLocal property is read-write in nonreplicated databases and read-only in replicated databases. To create a local object in a database that has already been replicated, set the object’s ReplicableBool property to False. To make your database replicable, set its ReplicableBool property to True. For more information about making additional replicas of your database, see the “Making Additional Replicas” section later in this chapter.

Important The Microsoft Jet database engine does not allow you to protect a replicable database with a database password. Before you begin using replication, remove any database password protection from the database you will be making replicable. Permissions defined for user-level security do not interfere with replica synchronization. For more information about how to remove a database password and how to define user-level security, see Chapter 10, “Managing Security.”