ACC95: "There Isn't Enough Disk Space or Memory" Error Message

 Last reviewed: May 14, 1997
Article ID: Q145772
The information in this article applies to:
  • Microsoft Access version 7.0

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you preview a report, run make-table query, or create a sorted recordset (in a query or in Visual Basic for Applications) using a table with hundreds of thousands records, you may receive one of the following error messages: 

   There isn't enough disk space or memory

   -or-

   There was not enough temporary disk space

CAUSE

The Microsoft Jet database engine version 3.0 has a built-in limitation of approximately 268 megabytes (MB) for its temporary files. When you preview a report or sort a recordset, the Jet database engine creates a temporary file (in your Temp folder), which it uses to sort your records. If the temporary file exceeds approximately 268 MB in size, then you receive the "There isn't enough disk space or memory" error message.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 7.0. This problem no longer occurs in Microsoft Access 97.

Keywords : EvnTemp kbenv kberrmsg
Version : 7.0
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
Resolution Type : kbfix

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: May 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.