Show All

About changing the design of a replicated database (MDB)

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

Before you change the design of any objects in your Design Master, follow these guidelines:

• Synchronize all replicas in the replica set before making design changes.
• Check all replicas to make sure that the name you are selecting for a new field or object isn't already being used as the name of a local object. (If you do choose the same name, the local object will be renamed.)
• Don't create relationships between tables when you intend to replicate some tables but keep others local.
• Make sure that the number of bytes you add to a field or the number of fields you add to a record doesn't exceed the maximum size for a replicated database.
• If you use linked tables, keep in mind that linked tables aren't automatically replicated. If you create a linked table in the Design Master, it's created as a local object and remains local until you make it replicable. When you make the table replicable, the link and the table are sent to all the replicas in the set. After the table appears in each replica, you can change the link in an individual replica or in the Design Master without affecting the other members of the replica set. To refresh the link in all members of the replica set, change the replicable linked table to a local table (in the Design Master), refresh the link, and change the table back to a replicable table.
• Any formatting included in PivotTable and PivotChart views used in tables, queries, views, stored procedures, and functions is not replicated when you set up replication for your database. You can replicate the format of PivotTable and PivotChart views in a form.