MS Access 2010 - I can't open a broken query in design view

I'm new to MS Access 2010 and am not a developer. In working with my database I have inadvertently 'broken' queries by changing a table name or deleting a table, etc.  When I try to open such queries in the normal manner from the Navigation pane (in either datasheet or design view), all I get is error messages.  I would really like to get to the query's design view and fix the problem rather than delete the query and recreate it.    

Any ideas or solutions?   Many thanks in advance.   WallyTee
WallyTeeAsked:
Who is Participating?
 
GrahamSkanRetiredCommented:
You will have to choose the SQL view and correct it there. Access cannot always interpret the incorrect SQL into a design view.
0
 
GrahamSkanRetiredCommented:
If the SQL is complex, it might help to reduce it to a legal starting point that can be understood and to add the complexity later.
0
 
Brian PiercePhotographerCommented:
Right click on the query in the navigation pane and then select Design View, that will open it without attempting to execute it.
0
 
WallyTeeAuthor Commented:
Thanks to all.  I'm OK now.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.