Access Security

[sbayeta]

Hi,

I've just setup security in my database, and it works fine. Now I'd like to know if it is possible to determine the currently logged user from VBA, since I'll be logging the actions users perform.

Is there any function that returns the logged user ?

Thanks in advance.

 

[ByteMyzer]

Yes, there is, and I'm sure you'll love how disgustingly complicated it isn't. The function is:

User()

 

[ghudson]

The CurrentUser function will do what you want if you are user Access security with workgroups and user names. The Environ function will help you grab info about the user and their computer.

MsgBox "Current User  = " & CurrentUser

MsgBox "Network ID =  " & Environ("UserName")

 

[sbayeta]

Thanks a lot for those replies. I'll try them both.