Environ() giving Undefined Function on some computers

[BroncoMarc]

I've got a database that many users here use that uses the Environ() command to identify the user. There are a few computers that come up with the error "Undefined Function 'Environ()' " when they load the database.

What's confusing is that all the computers here are ghosted off the same image. They're all running Windows 2000 / Office 2000.

Any ideas of what could be different that's making that command not be recognized?


Thanks..

- Marc

 

[maxmangion]

does all of the computers have the same references ticked ?

i.e. in the vba editor when you go to Tools -> References

 

[BroncoMarc]

The references on the computers that are giving the error are the same as mine:

• VB for applications
• MS Access 9.0 object library
• MS DAO 3.6 object library
• OLE Automation
• MS VB for applications extensibility 5.3
• MS Calendar Control

- Marc

 

[Pat Hartman]

Installing other applications, such as VB, that use shared .dll's can cause a problem for Access. Just open any code module, go to Tools/References, and make some change. Any change will do. The object is to force Access to refresh its references collection.