Queries with Expressions cause a Compile Error

[Dr Rubick]

I have a database with many tables and queries, which I have been developing
for several months now. Today, all of the queries which contain at least one
expresion started generating a compile error. I have not made any recent
changes to most of these queries, and they all refernce different tables.

The queries which only have simple field references still work fine
(including crosstab and union queries), but anything with anything more than
a simple reference (example: [Name]&IIF(IsNull([Title]),"",[Title]) )
generates a compile error. The exact text of the error text box is:

Compile error. in query expression '{the full text of the first query
expression in the query}'.

Any ideas what this could be? I'm using Microsoft Access 2000 (9.0.6926
SP-3).

 

[John Vinson]

I have a database with many tables and queries, which I have been developing
for several months now. Today, all of the queries which contain at least one
expresion started generating a compile error. I have not made any recent
changes to most of these queries, and they all refernce different tables.

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

John W. Vinson[MVP]

 

[Dr Rubick]

I did what you said, but it had no effect that I could see. None of the
references were "Missing", so I added one more in, closed and reopened Access
(the problem was still there), removed the new refernce, and closed and
opened access again (and the problem was still there).