Stop a user from opening an already-open database

[Lostguy]

Hello!

Any way so that when the database is use, if a second user tries to
access it, they get a message that says "The database is already being
used by User_______. Please try again later" and then the database
does not open.

I don't want more than one user at a time, and I would like the 2nd
user to be able to pointpoint who the other user is so they can talk.

Thanks!

VR/Lost

 

[Douglas J. Steele]

One approach would be to have a table to which users write when they open
the database.

http://support.microsoft.com/kb/285822/ shows how to read the ldb file to
determine who's logged in, but it may not provide you with adequate
information.

The logon name refers to the Access user name. If you don't have Access
User-Level Security applied, it will show up as Admin for all users. Only
knowing the computer name probably won't help you that much.