Question How to get a list of active users or computers

[aliciasmith]

In the laccdb file the computer users do not clear out when they close the database. So how do I easily get a list of computernames or usernames of users that are actively using the database?

 

[boblarson]

This should help:
http://support.microsoft.com/kb/285822

 

[aliciasmith]

Thank you. I already had that code but was missing the reference Microsoft ActiveX Data Objects 2.1 Library now it is working again. Yay!

 

[boblarson]

You probably should change that reference to 2.7 at least if you are on Windows XP or above. 2.1 is very, very old and (pre Windows 2000) and may introduce some problems if you need other functionality later on down the line.

 

[aliciasmith]

I was wondering about that. I'm on XP. I changed it to 2.8. Thank you again.

 

[jcajca]

Hello!

I am just updating this topic becauseI have currently the same problem: I'd like to see the list of the users connected to my Access 2007 database. I tried the code which is given in the link of boblarson, but unfortunately, I get this error on the line with "OpenSchema":

VBA compile error: wrong number of arguments or invalid property assignment.

Would u have any idea of solution ?



Thank you very much and have a nice afternoon!