Share this Page URL

Chapter 18. Maintaining an Access Databa... > Replicating an Access Database - Pg. 635

Maintaining an Access Database 635 Quick Check Q. If you convert a database saved in the Access 2000 file format to the Access 2002-2003 file format, can you still open the database in Access 2000? A. No, after the conversion, you can only open the database in Access 2002 or Access 2003. Q. Do you need to convert a database saved in the Access 97 file format to work with the database in Access 2003? A. No, you can open an Access 97 database in Access 2003 and update data, but you can't make any modi- fications to the database objects in Access 2003. Replicating an Access Database Replication is the process of making copies of a database (one or more) so that the set of databases can exchange modifications to the data or to database objects they contain. A mechanism known as synchronization is used to maintain the set of databases so that any changes made in one copy are applied to the others. With replication, users can change data in multiple copies of a database and synchronize data with a master copy of the database. The master copy (called the Design Master) is the only database in a set of replicated databases (often referred to as a replica set ) in which you can make changes to the database's design. The Design Master and related replicas are identified as a set by using a replica set identifier. When you replicate an Access database, several fields are added to the tables you replicate and several system tables can be added to the database as well. The fields added include a globally