MSQuery Returns "Out of Memory" Error with Action Query

Last reviewed: September 12, 1996
Article ID: Q147889
The information in this article applies to:
  • Microsoft Query for Windows 95, version 2.0

SYMPTOMS

In Microsoft Query, version 2.0, if you execute an action by using the SQL dialog box, the action query will execute successfully, but you may receive an "Out of Memory" error message.

NOTE: An action query is a query that updates a table or database using SQL commands, such as INSERT, UPDATE, and DELETE.

WORKAROUND

To workaround this problem, execute the action query using the Execute SQL command on the File menu in a query. To do this, follow these steps:

  1. On the File menu, click Execute SQL.

  2. In the Execute SQL dialog box, click the Data Sources button to select a data source for the action query.

  3. Type the SQL Statement, and then click Execute.

You should receive a message indicating whether or not the query executed successfully.

STATUS

Microsoft has confirmed this to be a problem in the products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


KBCategory: kbtool kbprb kberrmsg
KBSubcategory: xlquery

Additional reference words: 2.00 MSQuery



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.

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.