Optimize Access database performance by using the Performance Analyzer

You can use the Performance Analyzer to optimize the performance of a Microsoft Access database. You can also optimize the performance of a Microsoft Access project; however, the Performance Analyzer is available only in an Access database.

1. Open the Access database you want to optimize.
   
   
2. On the Tools menu, point to Analyze, and then click Performance.
   
   
3. Click the tab for the type of database object that you want to optimize. Click the All tab to view a list of all database objects at once.
   
   
4. Select the names of the database objects that you want to optimize. Click Select All to select all database objects in the list.
   
   
5. 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. Microsoft Access can perform Recommendation and Suggestion optimizations for you. You must perform Idea optimizations yourself.

6. 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. For additional suggestions on improving performance in other areas not covered by the Performance Analyzer, click .