Detect on db open if someone else has db open

[BRZ-Ryan]

I am using a local db which I will not be splitting. The intention is to only allow one person to have it open at a time to avoid entry conflicts and for speed.



Currently, if user A has the db open and user B attempts to open it, he gets the error 'The database has been placed in a state by user 'Admin' on machine ...". This is good, as it prevents it from being opened, but I'd like to use my own msgbox error which will indicate the exact person that has it opened (in the event it's left opened unintentionally so we can track down that user). I tried to use sub main() in a module but it doesn't work. I plan to write to a table the current users name on main form load, then on form unload, delete this user. When user 2 goes to open it, I want it to say 'Currently open by user As name, try again later".

Is there any function that gets called in VBA prior to the error above?

[JoeM]

Whenever the database is open, a "lock" is put on it, and a file with the same name as your database, but with a "laccdb" extension will be out there.
So, you could create a batch file or VBScript file for users to use to run the database (instead of opening directly).
You could have that script first check for the existence of the laccdb file, and if it exists (meaning someone already has the database open), you could have it return any message you want. The only thing is, I don't know if will be able to tell who exactly has the database open.

I did a search, and did find this link which can be used to find out who has the database open, but it looks like it would run right from Access, and not a script file: http://support.microsoft.com/kb/285822.