Use the Performance Analyzer to optimize an Access database
You can use the Performance Analyzer to optimize the performance of a Microsoft Access database. The Performance Analyzer is not available in an Access project.
- Open the Access database you want to optimize.
- On the Tools menu, point to Analyze, and then click Performance.
- Click the tab for the type of database object that you want to optimize. Click the All Object Types tab to view a list of all database objects at once.
- Select the names of the database objects that you want to optimize. Click Select All to select all database objects in the list.
- Repeat steps 3 and 4 until you've selected all the objects you want to optimize, and then click OK.
The Performance Analyzer lists three kinds of analysis results: Recommendation, Suggestion, and Idea. When you click an item in the Analysis Results list, information about the proposed optimization is displayed in the Analysis Notes box below the list. Suggestion optimizations have potential tradeoffs that you should consider before performing them. To view a description of the tradeoffs, click a Suggestion in the list and then read the information in the Analysis Notes box. Access can perform Recommendation and Suggestion optimizations for you. You must perform Idea optimizations yourself.
- Click one or more of the Recommendation or Suggestion optimizations you want performed, and then click Optimize. The Performance Analyzer will perform the optimizations and then mark them as Fixed. Continue this process until the Performance Analyzer has completed all Recommendations and Suggestions that you want it to perform.
To perform all Recommendation and Suggestion optimizations, click Select All, and then click Optimize.
To perform an Idea optimization, click the optimization, and then follow the instructions displayed in the Analysis Notes box.
Note The Performance Analyzer doesn't provide suggestions on how to improve the performance of Microsoft Access itself or the system it is running on.