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.