Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
At this point, I'd have to say try reinstalling Access.
Microsoft Access is not allowing me to compact and repair. Keeps saying its open etc
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
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.
60 answers
Sort by: Newest
-
George Hepworth 23,120 Reputation points Volunteer Moderator2022-02-20T14:59:01+00:00 What version of Access do you have installed?
-
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.
-
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
-
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."