How do I get the Windows User ID

[Ray Milhon]

I have an unsecured Access 2000 Database. I need to track the user's that
add new and edit old data. (new requirement) I know there is a dll that can
be used to get the Windows User information and I would like to use that to
save the user info. It's been quite a while since I've done that and I've
forgotten the syntax any help would be appreciated.

 

[Douglas J. Steele]

http://www.mvps.org/access/api/api0008.htm at "The Access Web"

 

[IgaJim]

Try this:

Function UNameWindows() As String
UNameWindows = Environ("USERNAME")
End Function

another helpful function:
Function TempDirectory() As String
TempDirectory = Environ("TEMP")
End Function

 

[Douglas J. Steele]

I always cringe when someone suggests using the Environ function to retrieve
the user ID, given how easy it is to reset environment variables.

The API approach to which I pointed is almost as simple, and is guaranteed
to be correct.

 

[IgaJim]

Oops, Sorry for the cringe Doug