PRB: Switching to SQL-Specific Query Clears Query Grid

Article ID: Q119222
Creation Date: 10-AUG-1994
Revision Date: 01-DEC-1996

The information in this article applies to:

Microsoft Access versions 2.0, 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

If you open a standard (select) query, switch the query type to a SQL- specific query using the Query menu, and then switch the query back to a standard query, the original query layout will be cleared. If you switch the query back to a SQL-specific query, anything you typed in the SQL- specific query will be gone.

RESOLUTION

To recover your original query, close the query without saving it. When you open the query again, the original layout will be restored.

STATUS

This behavior is by design, and is being reviewed for consideration for change in a future release of Microsoft Access.

MORE INFORMATION

Steps to Reproduce Behavior

Open any select query in Design view.
To switch the query to a SQL-specific query, point to SQL Specific, and then click Data Definition on the Query menu.
To switch the query back to a select query, click Select on the Query menu. Note that the query grid has been cleared.
If you switch back to a SQL-specific query, anything you typed in the SQL-specific query will be gone.
Close the query without saving it.

REFERENCES

For more information about SQL-specific queries, search the Help Index for "SQL View," or ask the Microsoft Access 97 Office Assistant.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.