RogerCooper
Registered User.
- Local time
- Yesterday, 18:21
- Joined
- Jul 30, 2014
- Messages
- 288
I have a module that executes a long series of queries listed in table. These queries spot missing & erroneous data in our ERP. I run automatically at midnight & noon.
Recently the same queries run at noon started taking more than x10 longer to run than the ones executed at midnight. I am generally working in the database at noon (using a different computer), but that has not caused problems before. In addition, if I run the queries by opening up a new instance of Access with same database, they run fine, even while the database is executing slowly. I compact the database every morning.
Some things I have tried without success"
* Shutting down everything and restarting (I do that every weekend)
* Create a new database and copying everything into it
Does anyone have any ideas on how to fix this?
Recently the same queries run at noon started taking more than x10 longer to run than the ones executed at midnight. I am generally working in the database at noon (using a different computer), but that has not caused problems before. In addition, if I run the queries by opening up a new instance of Access with same database, they run fine, even while the database is executing slowly. I compact the database every morning.
Some things I have tried without success"
* Shutting down everything and restarting (I do that every weekend)
* Create a new database and copying everything into it
Does anyone have any ideas on how to fix this?
Last edited: