Microsoft Access provides replication commands that you can use while working in your databases. By using the Replication command on the Tools menu, you can:
Microsoft Access Users If you have Microsoft Access, one of the easiest ways to become familiar with the concepts and procedures associated with database replication is to experiment with the Microsoft Access replication commands. Open an existing Microsoft Jet database in Microsoft Access, point to Replication on the Tools menu, and then click Create Replica to both convert your database to a Design Master and create a replica. You can then explore the changes made to the design of your database (these are explained in detail in the “Changes Made to Your Database When You Use Replication” section later in this chapter) and the similarities of the replica to the Design Master. Next, make a change to the data in the replica and a change to the design of a table in the Design Master, and then click Synchronize Now. You can then open the replica and Design Master to confirm that the changes appear in both members of the replica set.