By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

System Builtin Function cannot be read

P: 6
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!
Oct 9 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
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)
Oct 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.