• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 24. Replication Made Easy > Preventing Objects from Being Replicated

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 are replicated, the more effective the synchronization process is.

Designating that an object won't be replicated can't be done by using the Access user interface; it can be done only by using VBA code or the Replication Manager. To do this, set the KeepLocal property of the specific objects to True. When you try to set the KeepLocal property to True with VBA code, you get an error unless you have already appended the property onto the object. You must, therefore, include error handling in your code to handle this problem. Using the Replication Manager to flag an object as nonreplicable is covered in the section “Replicating a Database with the Replication Manager.” The code required to add the KeepLocal property to an object and set its value to True is covered in the section “Implementing Replication by Using Code.”


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint