user timer/clock

[NewbieHere]

I have several users using my database. Is there anyway to keep track of how much time each each user uses my database. like a built in clock/timer.

Thanxs

[Lee Smith]

Wow, this has been sitting here unanswered for a couple of months. Is this still a question you need answered, or did you figure it out or get an answer some place else.

One thought I had was to create a Audit Trail, or Field Modification solution.

Lee

[Ender]

The thought that comes to my mind is having a Session_Log file/table. Each time a user logs in, a record is created in this log for the current user, and stamped with the current date/time. When a user logs out (or closes the main file,) the last log record for the user gets closed out with the current date/time.

Then to aggregate these, simply use a relationship from the User file/table with a sum() function on the related Time Elapsed, or a columnar report in the Session_Log file/table.

The trouble is when the files don't close gracefully, or a network disruption kills the session. I don't see a great way to deal with this, other than to live with possible blanks for the session End Date/Time. I suppose you could frequently update a Last Activity Date/Time field in the Session_Log everytime the user navigates to another layout or something. Then use this in the Time Elapsed calc if the End Date/Time is empty.