Recording database usage

  • Thread starter Thread starter relativehunter
  • Start date Start date
R

relativehunter

I would like to automatically record in a table the amount of time someone is
in an Access database. I'm thinking that I can do something like record the
session start time, session end time, then build a query to calculate the
total amount of time. This is a single user database. Anyone have any
suggestions about how to carry this out?
 
Create a hidden form which gets launched at starup. Then set it up so that
when it opens it insert a new record in your tracking table with the now()
value for the start time and when the form closes it inserts the now() for
the close time. Then you can query till your hearts content!

But why this tracking? The time you will be tracking does not actually mean
they were working, just that they had it open somewhere on their desktop.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Back
Top