Terminal Server user name

  • Thread starter Thread starter Kevin Witty
  • Start date Start date
K

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
 
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
 
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)
 
Back
Top