NT username error access 2007 runtime

[DH010010]

I have an error displaying Environ("username") in access runtime 2007. In
2003 it works fine however in 2007 all i get is #name?. I have looked at a
module that there are numerious poste about - FOSUserNAme but i get the same
error.

In access 2007 I am using the runtime version so the databas can be
distrbuted to others on the network. But it is critical that the workstation
username is loggable.

any directions........ I have checked all the code but dont understand why
Environ("username) works in 2003 but not in 2007 runtime...... no code has
been changed......help would be good ;-)

 

[DH010010]

The database was built in 2007 (retail version) in .mdb format and works
great.... that is untill it is bundled to gether for runtime distrbution.

I did cont convert it to accde.......... should i do that?.... is that where
i went wrong?

 

[DH010010]

The code was cmpiled and no errors were raised.

I have just created a new db and a form in 2003 with just the
environ("username") in a text box on a blank form.

If i run this in 2003 it tels me my username. if i then click run as.....
and run it with the 2007 runtim it comes up with #name?

Could that function not exist in the 2007 version???

 

[Vera Smith]

I have an error displaying Environ("username") in access runtime 2007. In
2003 it works fine however in 2007 all i get is #name?. I have looked
at a
module that there are numerious poste about - FOSUserNAme but i get the
same
error.

In access 2007 I am using the runtime version so the databas can be
distrbuted to others on the network. But it is critical that the
workstation
username is loggable.

any directions........ I have checked all the code but dont understand why
Environ("username) works in 2003 but not in 2007 runtime...... no code
has
been changed......help would be good ;-)

 

[DHill009]

I found and fixed the problem!!!!

it has do do with sadboxmode. i found instructions on ms website:

http://office.microsoft.com/en-us/access/HA101674291033.aspx

hope this helps anyone else that gets stuck.

Thank you Chris for your help! ;-)