O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required