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. 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
  2. Anonymous
    2022-02-18T14:03:15+00:00

    Hi Grover, I am at sea here. Don't know what to do. I don't use Grammarly. Please guide. Even new files are having this problem. Thanks. And now all files it wants to open in shared mode. That's another headache.

    Ripal

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-02-20T14:42:39+00:00

    I am following.

    Having the same problem. I can't compact and repair any of my access files.

    I opened access, created a new, blank, database and was able to compact that but when I open up any of my other databases they all tell me another user is on and won't let me compact and repair.

    Was this answer helpful?

    0 comments
  4. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-02-20T14:59:01+00:00

    What version of Access do you have installed?

    Was this answer helpful?

    0 comments
  5. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-02-20T15:01:13+00:00

    At this point, I'd have to say try reinstalling Access.

    Was this answer helpful?

    0 comments