Active Users Log

[Guest]

Is there a way to create a table that will give you a list of the active
users that are currently in the database? I want to be able to see who is in
the database based on their windows login. Is this possible?

 

[Rick B]

You said it in your post. You must *create a table that will give you a
list*.

You have to create a table. You would update it when someone opens the
database and when they close it. The most common way is to have a form open
with the database as a hidden form. It will continue to remain open
(hidden) as long as the file is open. When the database is closed, the form
is closed. You'd have to write code in the form's open event to log an
entry in your table. You'd have to write further code in your form's close
event to either append an exit date/time to the table, or delete the
original entry. That is up to you. Personally, I'd record the open
date/time (and userid) and then I'd store the closed date/time. I'd have
three fields in my table. This will give you an audit trail if you need to
look at historical access.

If you don't want to do all of this, there are utilities out there that use
the ldb (locking file) and will give you a list of who is in the database at
a given time. You'd have to do a search and find the ldb readers.