Forum Discussion
Compact & Repair throws error saying file is in use
When trying to compact and repair any database created on my computer i get an error saying file is already in use. I have tried every possible way to fix this - reinstalled Office 365 tried multiple...
There is no Network share, I have created numerous databases all over C: drive (numerous folders), 😧 drive (another drive on my computer), removable USB drive. I have shut down and restarted numerous times. I have reinstalled Office 365. I have shut down anti-virus, shut down cloud based backups like Amazon and Google. I tried running in safe mode but access will not run in safe mode. I tried your suggestion with command prompt - all failed.
I have no more ideas - other than renaming and using the resulting Db1.accdb file onwards.
- I appreciate all your help.
I'm also out of ideas. I've tried compacting local files opened both read only and exclusively. Both of those worked.
The only way I can get errors us when I deliberately open a second copy of a running database and then try to compact it. That was the reason for all my questions, Doing that causes this error message- One final suggestion. I don't think you've yet tried compacting from another database which was item 3 in my First reply. Please try that as well
