One user in database at a time

  • Thread starter Thread starter skk
  • Start date Start date
S

skk

I would like to have only one user to be able to open the DB at a time.
Right now I can have the DB open (working) and another user can open the same
DB and work in it at the same time. I went into TOOLS/OPTIONS/ADVANCED/ and
changed the open mode to EXCLUSIVE but multiple users can continue to open
the DB at the same time.


Can I have only one user able to open the DB at a time?


Thanks for all help.
 
skk said:
I would like to have only one user to be able to open the DB at a
time.
Right now I can have the DB open (working) and another user can open
the same DB and work in it at the same time. I went into
TOOLS/OPTIONS/ADVANCED/ and changed the open mode to EXCLUSIVE but
multiple users can continue to open the DB at the same time.


Can I have only one user able to open the DB at a time?


Thanks for all help.
Click to expand...

That setting you changed is an Access setting (for you only), not a setting for
the file. You would need all users to open the file exclusively to get what you
want.

You could give each user a shortcut that uses the /excl command switch to open
the file and instruct them to always use that shortcut.
 
Back
Top