Share via

MS Access-Error Executing command prevents multiple users

Anonymous
2022-01-06T20:07:59+00:00

We have an Access database in Office 365. The database is used by approximately 30-40 users. The database resides on a Shared server.  We have the front end separated from the backend data. 

Approximately 2 weeks ago, the database started giving us this error message: “There was an error executing the command” whenever we try to open any of the forms we have to enter the data.  It will allow one or two users to access the database, but after that it won’t let anyone else use it.  They get the error message.  If we wait for a period of time, allowing someone to exit, then another person can get in. 

We didn’t have this issue prior to a couple of weeks ago.

Microsoft 365 and Office | Access | For business | 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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-06T20:25:07+00:00

    If you search this forum you'll find countless threads on this subject. I also have the most extensive article on the subject

    https://www.devhut.net/access-lock-file-issues/ 

    Pay particular attention to the comments!

    You are not the only one experiencing such issues.

    Your best bet is to stop updates, rollback to a prior stable build and move on.

    Was this answer helpful?

    0 comments
  2. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2022-01-06T20:14:28+00:00

    By now this is a FAQ, and you should have no problem scrolling back in this forum and finding plenty of posts reporting the same issue, as well as various remedies.

    Was this answer helpful?

    0 comments