Get Windows User

[Dimitris Nikolakakis]

I would like to keep in each record of table in access project the Windows
User and Compauter Name that has created the record or modified the record.
I will write the code in form properties on an event.

Thanks in advance

Dimitris Nikolakakis

 

[Tom van Stiphout]

On Fri, 23 Nov 2007 15:00:13 +0200, "Dimitris Nikolakakis"

Both items are listed here:
http://www.mvps.org/access/api/index.html

-Tom.

 

[Sylvain Lafontaine]

On SQL-Server, you can also use the function SUSER_SNAME; see:
http://technet.microsoft.com/en-us/library/ms174427.aspx

 

[Douglas J. Steele]

I always cringe when people suggest using an environment variable for this
purpose, given how easy it is to reset an environment variable.

All that's necessary is to open a DOS box, use the SET command to set the
USERNAME variable to whatever you want, then open Access using a command
line in that same DOS box. While the USERNAME isn't actually reset, it is
for the duration of that DOS box, so Access will see whatever the user tells
it to see.

Far safer, in my opinion, is to use the GetUserName API call. See
http://www.mvps.org/access/api/api0008.htm at "The Access Web" for a
complete sample.