access dependent on user

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database that I developed,it is stored on a shared drive,
and the user has to enter a password and username before they can enter the
database.

In order for the user to get into the database they must click on an icon
that is linked to the database.

In the target of the icon I have ented the term "excl" which prevents
multiple users from entering the database at one time. (as was suggested in
this group which I appreciate)

Is there a way to prevent multiple users from entering the database at the
same time but to allow me (the only one with admin rights)to access that
database even if another user is logged on.

I am new the the security features of access so if you can be as detailed as
possible I would appreciate it.

Thanks in advance.
 
Hi.
Is there a way to prevent multiple users from entering the database at the
same time but to allow me (the only one with admin rights)to access that
database even if another user is logged on.
Click to expand...

Sorry. If anyone has the database open exclusively, then no other users may
subsequently open the file, not even an administrator. The reason for this
is due to the way Jet locks the records for exclusive users, as opposed to
the extra protection Jet must provide to lock records when the file is
shared between multiple users. Jet is unable to switch these gears. Either
the database is opened exclusively or in shared mode, but not both.

You'll need to kick the exclusive user out before you can access the
database, either exclusively (recommended if you are making design changes)
or in shared mode.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)


"populating multiple tables"
 
Back
Top