Microsoft KB Archive/145772

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

Article ID: 145772

Article Last Modified on 7/5/2002

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q145772



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



SYMPTOMS
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.

Additional query words: there isn t enough disk space or memory

Keywords: kberrmsg kbbug kbfix kbenv KB145772

-

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

© Microsoft Corporation. All rights reserved.