The Access Replication function allows you to duplicate a database and synchronize the copies. Synchronization is the act of merging changes between two copies of a database. Synchronization updates all copies of a database to reflect the most current information. For example, if records are changed, added, or deleted in one copy of the database, synchronization will update other copies of the database.
One instance in which Replication is especially useful is when you save a copy of your database on a laptop, make changes to the copy while at home, and need to update the original database with the changes you made when you return to the office.
There are three ways to handle replication:
- Use the Briefcase provided by Windows 7 or 10
- Use Replication Manager, part of Microsoft Office, that allows you to copy a database and synchronize the copies
- VBA code can be used to create and maintain a replicated database
This course covers only the first of these methods. However, in order to use replication, you will need to have the Briefcase installed.