Forum Discussion
Access 2016 Compact and Repair
I have Access 2016 and a file I've used for many years. I sometimes will do a compact and repair on the file and it's always worked before. Yesterday when I tried, I got a message saying I couldn't compact and repair because the file was already is use. I'm the only user on my home computer. I worked with Microsoft tech support but they couldn't fix it. The file seems to work OK except for the compact issue. Also if I try to save a backup copy. Thanks for any help.
- George_HepworthSilver Contributor
GaryC1971 This recent bug might be the problem.
However, you should have received the fix for it in a more recent update.
Step one is to make sure your MS Office is up-to-date.Another issue that has been reported is that some Anti-Virus programs, especially McAfee, is the cause. Perhaps set an exception for Access would be appropriate in your AV if that is the problem.
- GaryC1971Copper ContributorThank you for the reply. I don't have the 365 version of Access which I assume provides updates. I purchased the Office Professional package as a one time purchase. I'll try the McAfee suggestion.