Q198755 ACC2000: Checking Who Logged into Database with Jet UserRoster.

Summary

By using VBA in Access 2000, you are able to keep track of the users who are logged into a database.

The user list lets you determine the number of users logged into a database. The list can be accessed via the ADO programming interface. Using this list you can obtain the following information for each user:

> User’s Computer name.

> User ID.

> Current connection of a user. (The ID of a user will remain until the last user has disconnected or the slot is reclaimed by a new user connection.)

> The way in which the user terminated their connection.

> The user list allows you to see the connected users so that you can request that they disconnect. This is also helpful in solving problems with corruption that may be caused by the actions of a certain user.