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 ...

Get Access 2002 Programming by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.