Detecting database closing 1

[PeDa]

I want to log users starting and leaving the database. I undertand the standard way to detect closure of a database is to load a hidden form at startup and include an Unload event for that form, however this does not work for me.
At startup I include

DoCmd.OpenForm "frmDatabaseIsInUse", acNormal, , , , acHidden

This contains

Private Sub Form_Unload(Cancel As Integer)
Call mod_ExecuteMyCommand("INSERT INTO tbLog VALUES(" & Str(pubAuditor_i) & ",'" & Format(Now, "yyyy-mm-dd hh:NN:ss") & "','Application closed')")
DoCmd.Quit
End Sub

mod_ExecuteMyCommand() is a working procedure.

 

[lameid]

I am almost certain that it will work on close. To be honest I do not think I have ever used unload to have any thoughts about when it does or does not fire.

 

[PeDa]

>I am almost certain that it will work on close.

Yes indeed; Close works where Unload does not. Thank you.