Monitor Connections

The Monitor Database Usage section shows all the current connections to your database:

If users disconnect, the time they close the database is shown.

Information on Connected Users

See every connection to each database. Click on the column to sort it:

Connections: An icon identifying the database connection type. The Legend provides information about the different icons.

Computer: The name of the user’s computer as it appears on your Windows network.

User Name: A more friendly user name for each computer based on a translation list you maintain.

Access Name: The name of the user logged into Access. This is not the user's Windows login name.

Connected: True if the database is connected, and False if not.

Suspect: True if the connection was left in a suspect state when the user (or the user’s computer) abnormally terminates Access, drops a network connection, reboots the computer, or performs another unsupported action.

Closed: Date and time the user disconnected from the database.

Database: Name of the database.

Write Activity to Log File

Enable this option to store all the user connections to record when people come in and out of the database. The information is stored in a table in a separate log database that you can open with the [Open Log File] button.