Can't get to SQL view

[ajarrell]

In Access, in SQL view, I modified a query to change one of the JOINS from inner to outer. I got the error message that the query couldn't be executed because of an ambiguous outer join. However, now I can't get back to SQL view to fix it. Whenever I click on SQL View, I get the error message again as if it is trying to execute the query, and I am left in Design view.

Is there a way I can get back to the SQL statement to change it back to what it was before?

Thanks!

 

[Ranman256]

Old access, mdb, was very forgiving if you had a bad join. It would break the joins and give you the SQL to correct.

NEW access, accdb, sucks and wont bother to show you the sql to fix. you must rebuild from scratch. (thank you Microsoft)

 

[JANR]

You can type this in the immediate window

?currentdb.QueryDefs("Nameofquery").SQL

and hit the enter button and your sql will print out, do yor corrections and paste it into a query

JanR