Whose logged on ? Access 2007

[alhotch]

I've seen alot of entries for finding out who is logged on to the database. I
am running a FE/BE Access 2007 database and would like answers for Access
2007 only. LDB Viewer (V1.8) will not work on Acc2007. Any help would be
appriiciated.

 

[Douglas J. Steele]

You should be able to use the code from
http://support.microsoft.com/kb/198755/EN-US/

If you're using the new ACCDB format, you'll need to change the connection
string as per http://www.connectionstrings.com/access-2007

Another option might be http://www.technipixel.com/accessldb.htm

 

[alhotch]

Thanks, Doug. I'll revisit the Microsoft KB article #198775. BTW, the
following
"Another option might be http://www.technipixel.com/accessldb.htm"
points to LDB Viewer Version 1.8. When I asked them about a version for
Acc2007, they said they plan to work on it in the future. As for now, the
version of LDB Viewer referenced by the above website (technipixel.com) is
V1.8 and DOES NOT support Acc2007 - Full or Runtime versions.

Thanks again, Doug.