• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 709
  • Last Modified:

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
0
WallyTee
Asked:
WallyTee
  • 2
1 Solution
 
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
 
KCTSCommented:
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now