Solved

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

Posted on 2012-03-18
4
631 Views
Last Modified: 2012-03-18
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
Comment
Question by:WallyTee
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 195 total points
ID: 37735166
You will have to choose the SQL view and correct it there. Access cannot always interpret the incorrect SQL into a design view.
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 37735172
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
 
LVL 70

Expert Comment

by:KCTS
ID: 37735298
Right click on the query in the navigation pane and then select Design View, that will open it without attempting to execute it.
0
 

Author Comment

by:WallyTee
ID: 37735958
Thanks to all.  I'm OK now.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook Free & Paid Tools
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now