Access Who is Logged In ?

[Steve_in_Kent]

Old LDB viewers no longer work for access 2010, i believe.

I want to determine who is logged in.. (typical back end on server, multiple front ends on pc, set up). The code here, http://support.microsoft.com/kb/198755/en-us

I can paste into my front end, and call it.. however, if i point to my current front end, it only lists me, and if i point it (in the code), to the back end, it generates a security error.
(even though the front end is logged in correctly, using the system.mdw as admin)

I do have code in the front end, based on a timer, to kick all users, and i have enabled it, but obiously, not working 100%, as i can't delete the LDB.

[HansV]

Is the backend password-protected, or have you set up user-level security?

[Steve_in_Kent]

User level security hans, but i sort of found out what i was looking for:-

After a long time a 'googling' this morning, and for anyone else that might read the thread..

You can just open the LBD file with Microsoft word. which gives you the computer name of every machine logged in to your database.

Then ping the computer name, gives you an IP address on the network.

then from a dos prompt, with the correct admin priviledges on the network.. type

wmic.exe /node:{IP address} Computersystem get username

returns the user who is logged on that computer. (you might then have to do a lookup in your user directory, if your company uses numbers, like mine.)

thanks

[HansV]

Thanks, might be useful to others.