MS Access 2003 Query error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using <Date() in the query criteria field and it works fine. I copy data
base and place on another workstation with Access 2003, etc, and get the
following error when the query runs: Function is not available in
expressions in query expression
Any clues on why this error occurs on one work station and not another?
 
There is a problem with one of the referenced libraries on the 2nd machine.

Press Ctrl+G to open the Immediate Window.
Choose References on the Tools menu.
Anything marked missing?
Any unneccary libraries referenced?

If nothing else works, try dereferencing them all (except Access and VBA
which are required). Then compact and close Access, open it again, and try
referencing those libraries again.

More on references:
http://allenbrowne.com/ser-38.html
 
Most likely, you have a problem with references. On the affected
workstation, open Access. Press Ctrl + G. This will take you to the Visual
Basic Environment. Click Tools > References. If any are marked as Missing,
remove the check mark, close the window, reopen the window and replace the
checkmark in the affected reference. If none are marked as Missing, then
write down the names of all of the references with checkmarks, remove those
checkmarks (for all that it will allow you to), close the window, reopen the
window and replace the checkmark in all those references.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
I wanted to implement your suggestion, but the 2nd machine in my case uses a
front end *.mde and does not grant access to the VB Editor...

....any ideas?

Thanks!!
M
 
I have a similar problem with a secured front end. The error comes after I
have logged in but leave Access with only 3 menu options: File, Window, Help.
Ctrl+G does not work in this case. (Access 2003). Any other suggestions as to
how I can access the references collection on this database?
 
Back
Top