Opening queries in design view when tables are not in the mdb

[Jim Pockmire]

...breaks the links between tables. Is there any way to open the query in
design view and preserve the links for diagnostic purposes?

 

[Douglas J. Steele]

You could always look at the SQL of the query.

CurrentDB.QueryDefs("NameOfQuery").SQL

 

[Jim Pockmire]

Thanks, Sometimes when opeining a query in design view MS-Access prompts

 

[Douglas J. Steele]

Yes, if you're opening the query through the application, you'll run into
problems. When that happens, simply say you don't want to save the changes,
then get at the SQL as shown.

 

[Jim Pockmire]

Occasionally the form closes saving the changes without the prompting me to
"not save" the changes. What might be causing this?

 

[Douglas J. Steele]

Huh? We were talking about queries, not forms. Where did the form come in?

 

[Jim Pockmire]

Yes - we a

Huh? We were talking about queries, not forms. Where did the form come in?

 

[Jim Pockmire]

Yes we are talking queries (my mistake). Sometimes upon closing a query,
MS-Access prompts to save the changes and sometimes it doesn't. This is a
problem if it automatically saves the query and there are broken links --
don't know why this is happening.

 

[Douglas J. Steele]

Sorry, I can't say I've ever noticed that happening, therefore I can't offer
any suggestions of why it might occur.