Code Blocked

[efpav]

I am on a Windows 2000 domain and running Access 2003

I can run all macros as an Administrator on the Domain, but all of my users get a "The expression you entered has a function name that Access can't find".

I have browsed the GPOs, but no such setting for Users...

Any ideas?

 

[willir]

efpav

Have you checked the references on the end user's workstations. Your macors may be referring to a reference that has not been instaled / added to on their desktop.

A real common issue is the DAO reference library.

Use CTRL-G to bring up the immediate window / debugger, and then look at "Tools" -> "References".

If you have a lot of users, consider downloading BillPowers (where are you Bill?) from his web site. The code goes through and creates a list of references. You want the one titled "automatic referencing". Import and run it, and look at the able "tblReferences".

http://www.wpower.fsbusiness.co.uk/

Richard