0

I have an access mdb database file with four tables in it. It's not overly large (46MB). It has run for the last two years with no isses, generally fast and quick to respond to queries.

I the last few weeks it has started taking 1-2 minutes to return a query made by DAO in Excel. When I open the database in the Access application (Access 2003) the tables freeze on load and there is a progress bar in the bottom left corner indicating that it is running a query. Once this finishes the table then loads, I suspect whatever is causing this behaviour is also causing the long query times.

Any ideas?

iShaymus
  • 113

1 Answers1

0

Repair & Compact the database

methods of Repair and Compact for Access

And if that doesnt fix it, and there is a reasonable amount of of VBA in the front end, try Decompile and Compile (followed by another Repair & Compact as above)

use the /decompile flag when opening the database,

Then go into the VBA editor (Ctrl + G is a quick way to get there) and from the menu bar, choose Debug -> Compile. Then do another Repair & Compact

Mike
  • 21