Microsoft Access is not allowing me to compact and repair. Keeps saying its open etc

Anonymous
2022-02-17T10:52:42+00:00

Microsoft Access is not allowing me to compact and repair the database. It keeps saying file is open. I made new database and imported files even then same issue and it says it is opening in sharing mode. I haven't shared with anybody. How to shut off this sharing mode. Mine is a single computer for home and is not part of any network. Please guide. Thank you. Ripal

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

60 answers

Sort by: Most helpful
  1. Anonymous
    2022-03-08T12:18:30+00:00

    Several people have spoken with them in the past week. We are all waiting for some formal news, but nothing yet. Nothing from them or Microsoft on the subject. All we know for sure is disabling McAfee resolves the issue.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2022-03-07T00:42:21+00:00

    I turned off the McAfee real time scan and I was about to Compact and Repair the database.

    Thanks to all for working a solution.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2022-03-04T12:09:11+00:00

    Have spoken to McAfee again and they want some logs which I will send. They are saying there are no other reports of the problems so can anyone else affected please contact them and report the issue. Many thanks.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2022-03-03T08:08:01+00:00

    @TheLeanMachine - Thank you. It is Mcaffee that is causing the problem. Uninstalled it and Microsoft Access works fine. I am going to speak to Mcafee customer care in a day or two and ask them to come up with a solution. All the same, for now we have figured out a solve for the moment. All reading this and facing the problem , uninstall Mcafee and reinstall or update your Access.

    Ripal

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  5. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-02-17T19:11:57+00:00

    The other reporting person has followed up:

    "I think I found the culprit. I turned off Grammarly from the system tray and now MsAccess no longer get stuck as a background process. When I turn Grammarly back on the problem immediately returns. What's interesting is that Grammarly does not activate when I use MsAccess. (Apparently its still listening). I tried turning off Grammarly for all my Office Apps but no effect on MsAccess. This seems like a serious security issue. I hope MS locks this down fast."

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments