Log database users

[ghudson]

The Environ() function works great unless you have the Sandbox mode turned on in
Access 2003. You will need to add this public function to your Access 2003 db's if you
want to continue using the Environ() funciton...

'This function is used to allow the use of the Environ function in Access 2003
    
Public Function Environ(Expression)
On Error GoTo Err_Environ
        
    Environ = VBA.Environ(Expression)
    
Exit_Environ:
    Exit Function
    
Err_Environ:
    MsgBox Err.Number & " - " & Err.Description
    Resume Exit_Environ
    
End Function

 

[GarageFlower]

Hi

Im trying to use this but every time my form opens it comes up with the debugger highlighting the onload event

Call FosUsername()

Any ideas people

Using access 200

 

[ghudson]

Hi

Im trying to use this but every time my form opens it comes up with the debugger highlighting the onload event

Call FosUsername()

Any ideas people

Using access 200

Why use that function? Use the Environ() [as before mentioned] instead.

Also, when did Access 200 come out?

 

[TimE]

I have started using this code to log users. I am not too concerned when they log out, just that they did. Can this code be modified to delete/remove the user from the log when they log out?

Thanks in advance for your help,
TimE