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

Chapter 23. Using Replication > How Replication Works

How Replication Works

At first glance, replication looks easy. You just use the Access menu bar and in a matter of seconds, you have a Design Master with several replicas. However, first impressions can be deceiving. An entire book could easily be written about just one aspect of replication. This does not mean that a comprehensive knowledge of replication is required to be able to use it effectively.

To keep tabs on the complexities of tracking database changes, much activity goes on behind the scenes. When you create replicas, Access creates several new hidden tables in the database. In addition to adding tables, Access adds fields to existing tables to manage synchronization and conflict resolution. Table 23.1 shows the fields that can be added to make the table replicable. Although at least four fields are added, you cannot view them without checking System Objects in Tools, Options, View.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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