Mar 23 2022 06:54 AM
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.
Mar 23 2022 07:29 AM
@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.
Mar 23 2022 07:40 AM