Forum Discussion
Solved
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...
- 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.
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.