User Log

[Alex Martinez]

Hello,

Can anybody recommend a website or a good book on how to create a form that
will show all users who logged on and logged off from the database. Thank
you in advance.

 

[Allen Browne]

The usual approach is to use a simple unbound Startup form to get the user's
name. When they click Ok, execute an Append query statement to add a record
to your logging table, and hide the form.

There is no Close event for the application, so use the Unload or Close
event of this hidden form to simulate it. Execute an Update query statement
on the last record for this user where the sign-out time is Null. (By "last"
I mean Max([SignOut]).)

If you just need to know who is logged in at any particular point in time,
see:
http://support.microsoft.com/kb/198755/en-us