cannot open the design view of a querie

[Guest]

In one of the queries that I wrote, I am trying to open the design view and
acees won't let me,why?

 

[Lynn Trapp]

Will it allow you to open it in SQL view? If so, then your query is probably
too complicated for Access to display in the QBE.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Doesn't let me to open it in SQL

Will it allow you to open it in SQL view? If so, then your query is probably
too complicated for Access to display in the QBE.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Lynn Trapp]

Then you may be suffering from some kind of corruption.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Van T. Dinh]

It sounds like your Query is corrupted. This happened to me once or twice.

Try Repair & Compact the database. If it still doesn't open in Design/SQL
view, just delete and re-create it.

 

[Duane Hookom]

First try to open the debug window by pressing Ctrl+G. Type something like
this into the window;
? currentdb.QueryDefs("qselYourQueryName").SQL
You can copy the SQL view (if provided) into a new, blank query.