Username of person who has the database open RRS feed

  • Question

  • At my previous job, I had some code I could run that would tell me who has open the current database. I am no longer at that job, but at my current job, I would like to be able to run the code to determine who has the database open.  Can anyone give me some sample code that would do this?  Thanks.

    Jill Marlow

    Wednesday, November 30, 2016 9:08 PM

All replies

  • I'm still using Access 2003 (mdb) databases.  I open the .ldb file with a text editor.  It lists the computers that have it open.  You could read it and extract the info.
    Wednesday, November 30, 2016 11:29 PM