Share this Page URL

Chapter 18. Maintaining an Access Databa... > Viewing Object Dependencies - Pg. 624

Maintaining an Access Database 624 Just the Steps Run the Performance Analyzer 1. 2. 3. 4. 5. Open the database you want to analyze. On the Tools menu, click Analyze, Performance. In the Performance Analyzer dialog box, select the objects you want to analyze, and then click OK. Review the results provided by the Performance Analyzer. To implement an item identified as a Recommendation or a Suggestion, select the item in the Analysis Results area, and then click Optimize. (You need to implement any items the Performance Analyzer identifies as an Idea on your own.) Quick Check Q. Why should you run the Compact And Repair Database command regularly? A. As you use an Access database--adding and deleting records, for example--the database file becomes fragmented and the size of the file increases. Also, an Access file occasionally becomes corrupted. Running Compact And Repair Database helps maintain a database so that it performs efficiently. Viewing Object Dependencies As a database changes over time, you might determine that you no longer need a particular form or report or that a table stores data that you no longer require. To keep the database current, you should delete the objects you no longer use. Before you delete a database object, however, you want to be sure that you aren't unintentionally deleting an object you need--a query, for example,