Alison Balter's Mastering Access 2002 Enterprise Development

Preventing Objects from Being Replicated

You might want to prevent specific objects in a replicable database from being replicated if, for example, certain data in your database is confidential or it's unnecessary for most users to see certain data. An employee salary table, for example, might be maintained and used in the master but isn't necessary for any of the replicas. The fewer objects that you replicate, the more effective the synchronization process is.

In the Access user interface, you can check the Make Replicable check box in the Save As dialog box when you create a new object, as shown in Figure 17.7 (if unchecked, the new object is local), or you can change the Replicable property of an existing object in its properties sheet, as ...