Query on users logged in & out

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I created a database, in use for many users on our network, all of them with
a user ID and password.
Is it possible to create a query (or something else) in order to have a list
of all the users who logged in & out, and when they did?
I.e.: User _ date & Time Log in _ date & Time Log out.

Thank you very much in advance.

Fabio CH
 
Only if you track that information in your database.

You would need to create a form that opens with the database as hidden. In
the forms onopen event you would write a record to a table. In the onclose
event, you'd update that record to include the time logged out.

This is not 100% since the application could crash and then the user would
appear to still be logged on.

Rick B
 
Back
Top