MS Access Multiuser - UserRoster shows multiple entries

Author

UserRoster shows multiple entries

anuruddha.j@gmail.com

2005-09-18, 8:24 pm

When I use the Jet UserRoster to find out who is currently logged into
my database (using the code from
http://support.microsoft.com/defaul...kb;en-us;198755), I find
multiple entries for each user - sometimes up to 5.

This happens even when I know for certain that no one else is logged
into the database. I expect to see two connections from my computer,
since I have the mdb open once in Access, and the ShowUserRoster sub
creates a new ADO connection, but why am I getting so many entries?
Also, I have a no-permissions account called ListUsers that I use to
get a list of groups in the workgroup file - this also shows up in the
list of logged-in users, although ListUsers does not have Open
permission for the database. Am I missing something very obvious here?
Help would be very much appreciated.

Sample output:

COMPUTER_NAME LOGIN_NAME CONNECTED
SUSPECT_STATE
SHADOWFAX Administrator
True Null
SHADOWFAX Administrator
True Null
SHADOWFAX Administrator
True Null
SHADOWFAX Administrator
True Null

I know this is formatted wrong, but it does give a picture; I seem to
be logged in 4 times, from the same computer. Baffling.

Thanks in advance, anyone who can help me sort this out.

Dervorin

2005-09-18, 8:24 pm

Sorry, one thing I forgot to mention: I'm using the Administrator login
for both the mdb as well as the ADO connection - if I change the
username on the ADO connection, I get two entries under Administrator
and two entries under the other username - Adrian in this case:

COMPUTER_NAME LOGIN_NAME CONNECTED
SUSPECT_STATE
SHADOWFAX Administrator
True Null
SHADOWFAX Administrator
True Null
SHADOWFAX Adrian
True Null
SHADOWFAX Adrian
True Null

Still twice as many as there should be, by my thinking.

Sponsored Links