Help saving logged on User information

[Fstetson]

I am keeping a log of various user account activities. Once logged in, I want to save/record that users name in a temp file for use while that user is performing other critical functions that my client wants to log as well. Such as crucial financial information that someone might delete. the4y want to knwo who did what and when. I am thinking a public variable that would open during autexec and delete tempfile upon database exit.




I am using the following code in the login form;


'///logs
Set ulog = CurrentDb.OpenRecordset("tbl_logs", dbOpenDynaset, dbSeeChanges)
With ulog
.AddNew
.Fields("logDate") = Date
.Fields("logTime") = Now()
.Fields("logActivity") = "Changed Password"
.Fields("logDetail") = "(" & Me.f_username & ")" & " Used Forgot Password Function "
.Fields("uID") = uI
.Update
End With
So, I am hoping you all might have a good resource you could refer me to or provide a suggested process.


Thank you very much.

[Welshgasman]

Google Access Audit log.

[Micron]

maybe this?

https://www.youtube.com/watch?v=3sIHMGxugL0&t=5s

You can use code with TempVars property to know who made the changes and post that along with the changes.

[June7]

For one approach to an audit trail, review http://allenbrowne.com/AppAudit.html