Forum Discussion
Strange problem compacting Access 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.
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.
I can understand why you don't want to do laborious workrounds.
However, have a look at the very useful utility in this link: https://www.devhut.net/windows-explorer-ms-access-database-right-click-context-menu/
Over the years, Access has got less and less tolerant of issues that can cause corruption. Compacting an open database can indeed cause corruption in certain situations.
Perhaps your database has a lot of open connections when you try to compact? However, that wouldn't explain the errors occurring when run externallyPerhaps this is a side effect of the most recent Access bug? Which Access 365 build are you using?
