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

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.