One user in database at a time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

skk - 15 Jan 2008 20:06 GMT

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.

Reply to this Message

Rick Brandt - 16 Jan 2008 00:32 GMT

> I would like to have only one user to be able to open the DB at a
> time.
[quoted text clipped - 6 lines]
>
> 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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message