Forum Discussion
Strange problem compacting Access databases
My installation of MS Access (Office 365 subscription) suddenly lost the ability to compact and repair databases, after more than two years of working fine. I always get the error "Could not use [db]; file already in use."
Strangely, every time I attempt to compact and repair a database, an event appears in the system log seemingly not at all related to Access. It's Event 19, Source OED, Provider Name Intel-SST-OED, description "Check the remaining resource budget. Module exceeds resource budget, failed to AllocateFwCps, STATUS = Insufficient system resources exist to complete the API.."
Intel-SST is Intel Smart Sound Technology. Sound on the machine (Dell Inspiron 14 5000) works fine. Nothing else is obviously wrong. Why would compacting and repairing an Access database fail and cause an error in the audio driver?
- Some people have reported that this problem lingers IF they also have MacAfee Anti-Virus installed. Try disabling it to see if that corrects the problem. Also, see if you can white-list Access in the MacaFee AV if that is the case.
10 Replies
- My Access was just updated to Version 2202 Build 16.0.14931.20132 today, and unfortunately it still can't compact and repair databases.
- Some people have reported that this problem lingers IF they also have MacAfee Anti-Virus installed. Try disabling it to see if that corrects the problem. Also, see if you can white-list Access in the MacaFee AV if that is the case.
- I do have MacAfee AV (also for years). When the problem first occurred, the first thing I tried (AV being always the prime suspect for anything) was to disable real-time scanning in MacAfee. That didn't help. But based on your suggestion, I went back and tried more variations. Closing Access, then turning off real time scanning, then reopening Access seemed to make the problem go away. Databases would compact again, strangely fast actually. It kept working even after I turned real-time AV scanning back on. So it seems to depend on the state of AV scanning at the moment the Access application is started.
Thanks for that suggestion.
Hello EasyOrImpossible,
I am glad to assist you.
You may operate some ordinary checks. Here are the things you must check before using the compact and repair method or any online repair tool.
- All users running this MS Access have the privilege where the MDB file in the directory exists. If JET cannot create an LDB file when logging into a database it will generate a 3045 error.
- You may check and confirm that the Access database is not marked as read-only.
- Check your file, that should not be scanned or opened in any anti-virus present on your system.
- Check your code to make it clear that you are not doing an explicit Close to the thing opened on your system and setting object variables to nothing as soon as you are done with something.
Check out this thread as well, if this could help your issue somewhere:
Thanks,
SuyashThomson
Actually never mind the part about Event 19. Maybe that is just associated with the beep that happens when the compact-repair fails, and not related to the failure itself. (The beep sounds fine, but perhaps the audio driver is still sending an error). Still, I have a spontaneous loss of ability to compact and repair, after no obvious changes to the machine. The only recent automatic update was KB4023057, which seems to relate to the update engine itself and seems not much related to Access.
- Have you tried compacting this externally e.g. from another database?
isladogsI dread resorting to a laborious work-around for something that should work, and worked fine until recently.
Compacting from the command line, or compacting while the database is closed, both give the same error.
