Microsoft KB Archive/115090

= "Out of Memory" Error with More Than 4,000 Tables =

Article ID: 115090

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q115090





SYMPTOMS
In Microsoft Query, when you access a database containing more than 4,000 tables, you may receive the following error message:

Out of Memory



CAUSE
This error occurs when Microsoft Query attempts to update the Tables list in the Add Tables dialog box.



WORKAROUND
To work around this problem, try eliminating the number of tables displayed in the Add Tables dialog box by using one of the following methods:

Method 1: Change the table options in MSQuery
The Add Tables dialog box displays a list of tables for the current data source. This list consists of tables, view, synonyms, and system tables. To specify which table types to display, click the Options button in the Add Tables dialog box. The Table Options dialog box is displayed, and you can then pick the table types with which you want to work. By doing this, you can reduce the number of tables that need to be added to the list. To change the table options, follow these steps:  Start Microsoft Query. On the File menu, click New Query, and select a data source based on one of the following ODBC drivers:

Btrieve

Excel

dBASE

FoxPro

Paradox

Text

If you do not have any of the drivers listed above on your computer, you can also choose other third-party ODBC drivers. In the Add Tables dialog box, click Options. In the Options dialog box, clear the check boxes for the following settings:

Views

Synonyms

System Tables

NOTE: This step assumes that you only want to see tables in the dialog box. Do not disable all the options (that is, leave the Tables option enabled) or you will end up with an empty list. In the Options dialog box, click OK. In the Add Tables dialog box, click Cancel.</li> On the File menu, click Close Query.</li> On the File menu, click New Query.</li> Choose the data source you originally intended to use.

If the problem persists, it may not be possible to use Microsoft Query with your database unless modifications are made to the source database so that fewer tables exist in a single database. If this is the case, you should try Method 2.</li></ol>

Method 2: Split up the database
This method involves dividing up your tables into two or more separate databases so that there are less than 4,000 tables in each database. Consult your database documentation for more details on how to perform this operation.

<div class="status_section">

STATUS
Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

<div class="moreinformation_section">

MORE INFORMATION
Additional query words: 1.00 2.00 MSQuery

Keywords: KB115090

-

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

© Microsoft Corporation. All rights reserved.