Login History

[SoxPats83]

i have a login form where i used the attached DB from this link http://www.access-programmers.co.uk/forums/showthread.php?t=163000&page=2 (it is the very last DB on the last page, not to be confused with the ones near the beginning of the thread. Thank You HTC!). what i would like is to know at what time users logged in and at what time they logged out (closed access)? any help would be appreciated. thanks!

 

[HiTechCoach]

i have a login form where i used the attached DB from this link http://www.access-programmers.co.uk/forums/showthread.php?t=163000&page=2 (it is the very last DB on the last page, not to be confused with the ones near the beginning of the thread. Thank You HTC!). what i would like is to know at what time users logged in and at what time they logged out (closed access)? any help would be appreciated. thanks!

I would recommend creating a table to log user activity.

When the user successfully logs in, create a record to log the activity. When the user logs out, create a record to log the activity.

This same table could be used to log other user activity in the database.

I would use an append query to add the record.

 

[SoxPats83]

I would recommend creating a table to log user activity.

When the user successfully logs in, create a record to log the activity. When the user logs out, create a record to log the activity.

This same table could be used to log other user activity in the database.

I would use an append query to add the record.

is there anyway i could get you to integrate this into your current DB in the attached thread? the way you put it makes it sound rather easy, but i am just unsure f my abilities to make it work.

 

[DCrake]

I have provided a new version which may be of use to you. See this Link.