Microsoft KB Archive/147889

= MSQuery Returns "Out of Memory" Error with Action Query =

Article ID: 147889

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q147889



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 the error message

Out of Memory.

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.

Additional query words: MSQuery

Keywords: KB147889

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.