?
Solved

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

Posted on 2012-03-18
4
Medium Priority
?
660 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 780 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

801 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