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

60 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. 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
  2. Anonymous
    2022-03-03T13:39:15+00:00

    Following the ideas, I can also agree that McAfee is the cause of the problem.

    I can stop real time scanning in McAfee, load any database and compact and repair works perfectly.

    Reenabling real time scanning and compact and repair fails. I'll also try to refer this to McAfee

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-03-03T15:13:30+00:00

    Just been on live chat with Mcafee, probably unsurprisingly the problem has to be escalated and they will call me back.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-03-04T04:18:42+00:00

    So after all of us breaking our head, we finally confirmed that it is Mcafee that is causing teh problem. I had not installed in one; uninstalled in another, and removed real time scanning in one. Works well now in all 3 machines. Will speak to Mcafee support regarding this. If anyone gets feedback from them do let us know. Thanks

    Ripal

    Was this answer helpful?

    0 comments
  5. 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