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: Newest
  1. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-02-17T19:07:10+00:00

    Thanks. It looks to me like both problem reports are for 64 bit Access. I don't know if that is relevant, but it's worth including in the discussion.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2022-02-17T17:37:48+00:00

    Hi Grover. Thanks for the help.

    This is the version I have. It says my app is up to date.

    Ripal

    Was this answer helpful?

    0 comments No comments
  3. George Hepworth 23,120 Reputation points Volunteer Moderator
    2022-02-17T16:20:48+00:00

    What version do you now have? This is the second report I've seen this morning that the problem remains despite installing the update which is supposed to include the fix.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2022-02-17T16:04:36+00:00

    Thanks Karl, I suppose it is this, but I updated my Office 365 today and still the error occurs. Not only does it say the file is open and not allow me to compact and repair, but now I get another message saying it will open my file in only share mode as it is already open elsewhere. I cant understand how to solve this. Mine is a standalone computer with no other networked computer or sharing of any kind whatsoever. Even after going to client in account and ensuring that the file is not marked as shared it still does the same thing. And I know it is an error from the applications end as even new database files that I create now just for checking have the same problems. I hope somebody from Microsoft is also reading this. I even uninstalled and reinstalled Office 365 yesterday.

    Ripal

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2022-02-17T11:24:17+00:00

    Was this answer helpful?

    0 comments No comments