Forum Discussion
lytell
May 06, 2021Copper Contributor
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...
isladogs
May 06, 2021MVP
Hmm. Very odd.
Was the lock file deleted? Did you find any running instances of Access in background processes?
If you try to make changes to a database do you get any warnings that there is another copy already running?
One last try. Use the Run command to compact it. To do so, you need to type the Access program file path followed by your application file path followed by /compact and enclose both sections in quotes. Does that make sense?
Was the lock file deleted? Did you find any running instances of Access in background processes?
If you try to make changes to a database do you get any warnings that there is another copy already running?
One last try. Use the Run command to compact it. To do so, you need to type the Access program file path followed by your application file path followed by /compact and enclose both sections in quotes. Does that make sense?
- lytellMay 07, 2021Copper ContributorWas the lock file deleted? Did you find any running instances of Access in background processes? NO
If you try to make changes to a database do you get any warnings that there is another copy already running? NO - lytellMay 07, 2021Copper ContributorSame Error message. This is insane.
- isladogsMay 07, 2021MVPYes I agree but please could you answer each of my questions from my last post