Knowledge Base

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

Article ID: 145772

Article Last Modified on 7/5/2002

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