ACC2000: Error Message: "There Isn't Enough Memory Available to Perform This Calculation" (247568)
The information in this article applies to:
This article was previously published under Q247568 SYMPTOMS
In Microsoft Access 2000, when you run a long script or a script with repeating actions, Access eventually runs out of memory and returns the following error message:
There isn't enough memory available to perform this calculation.
Scripts that ran properly in Access 97 will not run to completion in Access 2000 because of memory restrictions.
CAUSE
Access does not free memory used for each script until the script has completed all of its actions. Scripts are now double in size because Access 2000 scripts are Unicode and Access 97 scripts are not.
RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).
To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:
245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.
| Modification Type: | Minor | Last Reviewed: | 10/17/2005 |
|---|
| Keywords: | kbHotfixServer kbQFE kbbug kbfix kbQFE KB247568 |
|---|
|