Database prevented from being opened or locked

[Kozbot]

Hello

I have a database that is being shared on a network folder. I have about 4 different people using it at the same time.

Occasionally, someone gets the message "The database has been placed in a state by user "admin" on machine MDSOUTH (our server) that prevents it from being opened or locked" and no one can open the database till everyone closes it.

No one is changing the design at the time. Why does this message occur?

 

[bob fitz]

If a db has simultaneous users it should be split into a single backend on the server and a copy of the frontend on each users machine.

 

[Kozbot]

If a db has simultaneous users it should be split into a single backend on the server and a copy of the frontend on each users machine.

Yes I can on doing that.

But why does this message occur randomly? It opens fine 98% of the time.

 

[bob fitz]

Yes I can on doing that.

But why does this message occur randomly? It opens fine 98% of the time.

I'm sorry but I don't know the answer to this question, but splitting the db has, IMHO, a good chance of fixing the problem. Leaving it unsplit may lead to corruption of the db.