System Builtin Function cannot be read

[Spin]

Hi,

I have a rather intricate series of linked database over 2 GB in size on a server that is being accessed by over 20 computers. Two of these computers cannot recognize built-in functions (BIF) like Date (), Now (), etc., which drives a great deal of our charts and data analysis. These two computers access the same forms and reports on this server as all the rest, but somehow the BIFs come up as NAME#?. My gut says that their MS Access system executable programs may be setup is differently than the rest. It should be noted that both of these computers have been newly added to access this data. Is something wrong with their setup or security permissions??? Stumped!

[nico5038]

Check the references on the "error machines".

Open some VBA code (e.g. by pressing [CTRL+G]) and select Tools/References.
Each libraryname starting with "MISSING" must be unchecked and (e.g. microsoft DAO version x.xx) replaced when necessary.

As access doesn't cleanup added libraries, often unnecessary refenreces are present.
Just delete as many as possible without getting an error executing "Debug/compile all modules"

Nic;o)