Last usage

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

Guest

Is there a way to determine when a user last used or last access a database?
I need to provide a list of when all users last used an Access 2002 database.
The users are setup in the Access 2002 security file.

Any help would be greatly appreciated. Thank you in advance.
 
Rena - you might make a table with two fields : username and loginDate. Then
when your startup form opens, run a query to update this table, setting
loginDate = date() where username = currentuser().
hope this helps
-John
 
Thanks John. I will give that I try.

John Welch said:
Rena - you might make a table with two fields : username and loginDate. Then
when your startup form opens, run a query to update this table, setting
loginDate = date() where username = currentuser().
hope this helps
-John
Click to expand...
 
Back
Top