Terminal Server user name

[Kevin Witty]

I'm about to deploy Access 2003 in a terminal server environment. I'd like
to be able to capture theTS (Windows) user logon name from within access to
track who's doing what. In a client-server environment I use MSLDBUsr to
capture the computer name, but I doubt this will work now. Any suggestions?
Environmental variable I can grab? (Although no search I've done on
"environmental variable" and Access has turned anything up.)

Kevin

 

[Dan Artuso]

Hi,
This will probably do what you want.
http://vbnet.mvps.org/code/core/getusername.htm

 

[Kevin]

Hey, Dan, thanks! It retrieved my full signon name and not the computer
name from my stand-alone machine... From your prompt response I suspect
it'll work also on TS when I try it on Tuesday. Maybe now I can stop
having to distribute MSLDBUsr!

Boy, I wish I got answers to all my questions as quick as this!

Kevin

 

[david epsom dot com dot au]

In Access, 'Environ$' gets you the environment variables.
At many locations there is a 'username' environment variable,
so you can use =Environ$("UserName")

This isn't better than using the windows API, just easier
to type :~)

(david)