Stopping query when opening in design view

[Dkline]

We have a query of queries. Each of the underlying queries are looking at
linked tables or Excel spreadsheets. Even when we open this in design view
Access chews for a while before opening in the design view. My presumption
is that it does run the query of queries so that when you switch to
datasheet view it's ready for showtime.

First question: if I open a query of queries in design view, does it still
run the underlying queries?

Second question: if the answer is yes - any way to stop it?

 

[Eric Butts [MSFT]]

Hi,

No to the first question which answers No to the second question.

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| From: "Dkline" <[email protected]>
| Subject: Stopping query when opening in design view
| Date: Wed, 16 Jun 2004 14:33:40 -0400
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
| Message-ID: <#[email protected]>
| Newsgroups: microsoft.public.access.queries
| NNTP-Posting-Host: mail.philafin.com 151.197.144.178
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.queries:204129
| X-Tomcat-NG: microsoft.public.access.queries
|
| We have a query of queries. Each of the underlying queries are looking at
| linked tables or Excel spreadsheets. Even when we open this in design view
| Access chews for a while before opening in the design view. My presumption
| is that it does run the query of queries so that when you switch to
| datasheet view it's ready for showtime.
|
| First question: if I open a query of queries in design view, does it still
| run the underlying queries?
|
| Second question: if the answer is yes - any way to stop it?
|
|
|

 

[Dkline]

Thanks for the reply.

For my own edification, what does happen when you open a query in design
view? At least some checking that all the pieces are available - no bad
links, etc.

 

[Dkline]

I was poking around of the Office website and found this article.

Access 2002 Desktop Developer's Handbook
Chapter 15: Application Optimization

http://www.msdn.microsoft.com/library/en-us/dnacbk02/html/odc_4009c15.asp?frame=true

Within the article is gves a tip about optimizing a query by recompiling it
by opening it in design view. Is there an article that would tell me what
exactly does go on when you open a query in design view i.e. the sequence of
events?

Thanks.