The following steps comprise the replication process:
Making a database replicable
Creating and distributing replicas
Synchronizing replicas with the design master
Resolving conflicts
These steps can be completed in the following ways:
Through the Access user interface
By using the Windows Briefcase
By using the Replication Manager
By using ADO code
A brief discussion of replication is covered in this chapter. An overview of each alternative for replication is outlined in the following sections. For the details of the replication process and how to implement replication in your own development environment, please consult
Alison Balter's Mastering Access 2002 Enterprise Development .
The Access user interface gives you a series of menu items that allow you to perform all the steps of the replication process. The Tools, Replication menu has the following options: Create Replica, Synchronize Now, Partial Replica Wizard, Resolve Conflict, and Recover Design Master.
The Windows Briefcase supplies the foundation Access needs for the replication process. Users can simply drag a database file to the Briefcase to replicate it, make changes to the file while on the road, and synchronize the replica with the design master when they reconnect to the network. This is done because, when Access is installed, it registers a special class ID with the Windows Briefcase. When a database is dragged to the Briefcase, the Briefcase's Reconciler code is called. When the user selects Update Selection or Update All from the Briefcase menu, the Merge Reconciler is called. Briefcase replication is available as an installation option through Windows 95, its successors, and Windows NT 4.0 and later.
The Replication Manager is a sophisticated tool that's part of Microsoft Office 2000 and Office 2002 Developer. It's a mandatory player in the replication process when you're managing many replicas. Besides providing basic replication functionality, the Replication Manager lets you schedule the synchronization of replicas. In fact, the Replication Manager allows you to manage and intricately control all aspects of the replication process. The Replication Manager is covered in detail in
Alison Balter's Mastering Access 2002 Enterprise Development .
Most aspects of the replication process can also be done by using ADO code, which can be used to make a database replicable, create and synchronize replicas, and get and set properties of a replicable database. ADO can easily be integrated with the other methods of replication. Although it requires the most time and effort on your part, ADO code lets you base replication on events rather than time and give your users a custom user interface for the replication process.