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

• Microsoft Access 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          : kbenv kberrmsg EvnTemp 
Version           : 7.0
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 19, 1999