environ("UserName") is not working on new computer

[Lim Heng Sin]

environ("UserName") is working on my computer. However,
when my friend buy a new computer and copy the MS Access
file i developed but it's not working in his computer. I
go to Tools->Reference to check maybe his computer is
missing any dll or ocx files. But he have all the files in
his computer.

THe error message is stated that Environ("UserName") is
having some problem.

Any idea on this problem?

 

[May]

What kind of error message you got?

May
MCP in Access and SQL Server

 

[Douglas J. Steele]

As far as I'm concerned, relying on the UserName environment variable is a
bad idea: it's too easy to reset its value.

Instead, use the API call illustrated in
http://www.mvps.org/access/api/api0008.htm at "The Access Web".