Why is my MS Access database so slow?

How do I fix a slow Access database?

Help Access run faster1In this article. ... 2Help improve performance of a local database. ... 3Turn off Name AutoCorrect. ... 4Set the database to compact and repair automatically. ... 5Open the database in exclusive mode. ... 6Turn off AutoCorrect options. ... 7Help improve performance in a multiuser environment. ... 8Split the database.

How do I improve my Access database?

Try these five tips to boost the speed of your database:1Make sure all of your tables have primary keys. Running a table without a primary key is like running a four-cylinder engine with only two active pistons. ... 2Optimize by adding secondary indexes. ... 3Be like an atom and split. ... 4Use Compact and Repair. ... 5Load only what you need.

How do you improve query performance in Access?

Microsoft Access Table Performance Tips1Normalize Your Tables. ... 2Every Table Should Have a Primary Key. ... 3Primary Key Should be One Field and Numeric. ... 4Tables Should Participate in Relationships. ... 5Eliminate Unnecessary Subdatasheets. ... 6Choose the Optimal Data Types. ... 7Add Secondary Indexes As Necessary. ... 8Don't Over-Index.

How do I clear the cache in Access?

One of the links above lead me to search under "File > Current Database > Caching Web Service and SharePoint tables." The option to "Use the cache format that is compatible with MS Access 2010" was already checked, but I enabled the check box for "Clear Cache on Close" and closed the database. Voila!