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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access