ACC95: "There Isn't Enough Disk Space or Memory" Error Message (145772)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
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.
| Modification Type: | Major | Last Reviewed: | 7/5/2002 |
|---|
| Keywords: | kbbug kbenv kberrmsg KB145772 |
|---|
|