Microsoft KB Archive/111777

PRB: Query Information Lost Switching to SQL-Specific Query

PSS ID Number: Q111777 Article last modified on 03-13-1995

2.00

WINDOWS

= 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.