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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
invalid vertical bar 2
How to change Number to Text 1
Open up a query in design view 3
Windows cannot find file 12
Access 2007 closes without updating recordsource 8
Invalid Vertical Bar Error 2
Access Query error locks design view 1

Top