Last usage

[Rena]

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.

 

[John Welch]

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

 

[Rena]

Thanks John. I will give that I try.

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