Depending on your computer's configuration and your working environment, there are several things you can do that may improve the performance of Microsoft Access, your Microsoft Access database, or your Microsoft Access project.
If you are optimizing the performance of an Access database, the best place to start is with the Performance Analyzer. You can use the Performance Analyzer to analyze a whole database or just selected objects in a database. The Performance Analyzer can also make some proposed changes for you if you want.
Improve the performance of Microsoft Access and your system
Improve performance of linked tables
Improve external SQL database performance
Improve performance in a multiuser environment
Improve find and replace performance
Improve form and subform performance
Improve list box and combo box performance
Improve report and subreport performance
Improve data access page performance
Read about making your database an MDE file to improve performance
Improve Visual Basic for Applications performance
Optimize Microsoft Access project performance
Compact an Access database or Access project automatically when you close it