Getting user login in secured database 1

[KeyserSoze]

I have a database that I have created users and groups in a workgroup file. In some activities, I would like to store the user's login in an auditing table. Is there a way to lookup the user's database login name?

Thanks!

 

[jrbarnett]

Yes, just use the CurrentUser function, for example

Msgbox "Current user is: " & CurrentUser

John

 

[KeyserSoze]

Sometimes I cannot see the forest because of the trees.

Thanks, John!