PRB: Query Information Lost Switching to SQL-Specific Query
  
PSS ID Number: Q111777
Article last modified on 03-13-1995
 
2.00
 
WINDOWS
 

---------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Access version 2.0
---------------------------------------------------------------------
 
SYMPTOMS
========
 
When you switch a query from a normal query type (Select, Delete, Append,
and so on) to a SQL-specific query type (Union, Pass-Through, or Data
Definition), you lose all the existing information, such as added tables or
expressions, in the query.
 
If you add information to a SQL-specific query and then switch the query to
a normal query type, you will lose any SQL information in the query.
 
CAUSE
=====
 
When you switch from a normal Query window to a SQL-specific Query window,
Microsoft Access clears the Query Design window. Microsoft Access also
clears the Query Design window when you switch from a SQL-specific Query
window to a normal Query window.
 
STATUS
======
 
This behavior is by design.
 
MORE INFORMATION
================
 
Steps to Reproduce Behavior
---------------------------
 
1. Start Microsoft Access and open the sample database NWIND.MDB.
 
2. Open the Catalog query in Design view. Note the added tables and the
   information in the query grid.
 
3. From the Query menu, choose SQL Specific, then choose any of the
   three SQL-specific query types shown.
 
4. Type the SQL command SELECT in the Query window.
 
5. From the Query menu, choose Select. Note that the original query
   information is gone.
 
6. From the Query menu, choose SQL Specific, and then choose the
   query type you chose in step 3. Note that the SELECT statement is
   gone.
 
7. Close the query without saving the changes you made.
 
Additional reference words: 2.00 Queries
KBCategory: kbusage
KBSubcategory: QryOthr
=============================================================================
Copyright Microsoft Corporation 1995.
