Maintaining an Access Database 645 Q&A Q1: A1: How often should I back up a database? How often do I need to run Compact And Repair Database? The answer to these questions depends in part on how important the data is. Databases that store information that is used every day and that is vital to the operation of an organization should be backed up daily or on very frequent cycles. The easiest way to ensure that you run Compact And Repair Database regularly is to select the option Compact On Close on the General tab of the Options dialog box. Do I always need to replicate a database if the database is going to be used by more than one person? No. You can set up Access so that a database is opened as a shared database. By storing the database file on a network server, users with permission to use the database can open it and work with the data. You can use the record locking options described in this chapter to manage data conflicts. Replication is useful in situa- tions when you need to travel with a copy of the database (create a partial replica if you need to use just a subset of the data) or when the users of the database work in different geographic locations, for example. For a replica set, do I need to synchronize changes to database objects made in the Design Master as well as changes to the data? Yes, if you want the changes you made to the database object to be included in each database in the replica set, you need to syn- chronize the replica set. Q2: A2: Q3: A3: On Your Own Here are some exercises you can perform on your own to gain more experience with the topics covered in this chapter: 1. Open the HelloWorld18 database. Select a table, query, form, or report in the Database win- dow, and then click View, Object Dependencies. Scroll through the dependency information Access displays to see the relationships between the objects in the database. Open the Northwind sample database, and then run the Performance Analyzer. Examine the results the Performance Analyzer displays for the database that ships with Access. Make a copy of a database you've designed (or use a copy of the HelloWorld database). Create several replicas (at least more than one replica). Open the databases one by one, and create data conflicts by entering different values in the same field. Synchronize the databases, and use the Conflict Viewer to resolve the conflicts Access identifies. 2. 3. After you complete this chapter: · To learn about a key component of managing a multiuser database--securing a database--go to Chapter 19, "Implementing Security."