exclusive access and users

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

Guest

I have a database that I have set to exclusive and have users that login
under one user name and I would like to see if there is a way to show a new
error message so when a user opens the database and it is locked it shows the
current login name for the user that is logged into the network? I appreciate
any help. Thanks.
 
Erik said:
I have a database that I have set to exclusive and have users that
login under one user name and I would like to see if there is a way
to show a new error message so when a user opens the database and it
is locked it shows the current login name for the user that is logged
into the network? I appreciate any help. Thanks.
Click to expand...

The "Default Open Mode - Shared or Exclusive" is an option for your
installation of Access. It is not a setting for the file that affects all
users of the file. You would have to change that setting on all users PCs
or provide them with a shortcut that specifies that the file be opened
exclusively using the /excl command line argument for Access.

There is no way to provide the message you want as that would require
running some code and if you can't open the file there is no way to run any
code.
 
Back
Top