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...