Forum Discussion

GaryC1971's avatar
GaryC1971
Copper Contributor
Mar 23, 2022

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_Hepworth's avatar
    George_Hepworth
    Silver 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.

    • GaryC1971's avatar
      GaryC1971
      Copper Contributor
      Thank 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.

Resources