Compile Error on Environ

[LB79]

Hi all,

I have a strange going on with Access security.

In my Access 2007 database I have

[SIZE=3][FONT=Calibri]Public Function User()[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]User = Environ("UserName")[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]End Function[/FONT][/SIZE]

Which allows name logging when data is amended.
This works well for me every time, but when some colleagues open the database, it debugs to that piece of code saying Compile Error cannot find object or library.

Any help is appreciated.

Thanks

 

[boblarson]

Try using:

User = VBA.Environ("UserName")

 

[LB79]

Hi Bob,

Thanks for that which seems to have resolved that error. But now its doing the same for other functions. It seems to be happening to about half the people using the database. We all have the same OS and version on Access. Looking at the VBA references for the person trying to access it today, the have MISSING: on a couple of items. Perhaps thats causing the problems? Ill check a few things out and let you know if im sucessful or not.

Thanks again

 

[boblarson]

Yes, having MISSING there would cause problems. What are the ones which are coming up as MISSING?

 

[LB79]

Thanks Bob - Ive resolved the MISSING items. One was Microsoft Office Outlook View Control, and the other was Microsoft Visio Viewer 12.0.