rescue a corrupted query 1

[simon551]

Hi,
I get this message when I try to run, view, change, design my query: Syntax Error in FROM Clause.

I can't open the query for modification. Is there a way to work around this errror?

 

[dhookom]

Press Ctrl+G to open the immediate window. Then type in something like:

? CurrentDb.QueryDefs("qselYourQuery").SQL

You might need a reference to the MS DAO library in order to do this.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]