Thursday, February 17, 2005

Get the User Name in Access

To know the Windows user id currently logged in, in a text box on an Access form, type =ENVIRON("USERNAME") .

This will work immediately in Access 2000. But if using Access XP, then by default it will error out because the macro security level is set to Medium. To change this, go to the top menu, choose: Tools / Macro / Security / Low.

2 comments:

Anonymous said...

This works for windows login. But do u have any idea to get access users those are defined using security wizard?

natek said...

CurrentUser()