Clicking Ok in query error pop-up closes window - cannot fix error

M

Mary W

I received an Access 2003 db that I open in Access 2002. When I open one of
the queuries in the design view, I get an "Invalid use of vertical bars in
query expression". When I click OK, the query window closes so I cannot fix
the query.
 
A

Allen Browne

Open the Immediate Window (Ctrl+G)

Enter:
? CurrentDb.QueryDefs("Query1").SQL
substituting your query name for Query1.

Copy the text that is output as a result, and paste into (say) Notepad. Fix
the query statement up. Then create a new query, switch to SQL View, and
paste in the corrected SQL statement.
 
Top