Db Lock

  • Thread starter Thread starter RSusanto
  • Start date Start date
R

RSusanto

Hi,

I have Access application on the server. Sometimes when somebody open the
application, then the other user will not be able to run it.
the message is

" the database has been place in a state by user 'admin' on machine '123'
that prevents it from being opened or locked."

So how can I solve this problem to make multiuser ?

thanks
 
Split your database into two databases. The Backend with the original tables
and only the tables reside on a server type machine. The Frontend, which
contains the linked tables from the Backend plus the original queries,
forms, reports, etc. resides on each users machine.

This will make your database true multiuser.

Access has a built-in database splitter. Make a copy of the database and
store in a safe location. Then implement the split on a copy. Ensure no one
is in the database when you do this.
 
Back
Top