UserName

[alvaro]

Hi
I have a form and I need that everytime someone makes an update to a record of a table, his/her username has to be recorded on that record. In Windows, my username is AG, but ACCESS always returns me the ADMIN user, not AG. What am I doing wrong? I need "AG" not "ADMIN"

Thanks in advance!

 

[James Goodman]

In order to get the Windows username use:
Environ("UserName")

By default, when you open an access db you open it with the admin login
unless specific security is setup...



--
James Goodman
MCSE MCDBA
http://www.angelfire.com/sports/f1pictures/

Hi,
I have a form and I need that everytime someone makes an update to a

record of a table, his/her username has to be recorded on that record. In
Windows, my username is AG, but ACCESS always returns me the ADMIN user, not
AG. What am I doing wrong? I need "AG" not "ADMIN"!