One user in database at a time

[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.

 

[Rick Brandt]

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.

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.