Log User Movements

[Peter McCartney]

Hello All! A97 Thanking anyone for a reply:

Once a user has logged into a database, is there a way to log what forms or
reports they are using in a table or query, through code.

Database only on one computer.

Peter McCartney

 

[DanK]

YES

ONE way would be to have a table with 3 fields: User,
Location and Time.

Set up Global variables, say U, L, and T.

Have a 'Log In" form users first see which sets the
variable U. You can use password stuff to ensure it's
really them. Then, whenever a Form or Report is opened,
have the table populated with the value U. L is the name
of the form or report that was opened and T is defined as
Now().

Looking through the table you can see who went where and
in what order they did it in. You can also magnify this
idea with variables located at different controls on a
form if you wanted to track their exact movements in a
form as well.

email me if you need to.