Article ID: 247568
Article Last Modified on 10/17/2005
APPLIES TO
- Microsoft Access 2000 Standard Edition
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:
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)
STATUS
Microsoft 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.
Additional query words: there isn t enough memory available to perform this calculation
Keywords: kbbug kbfix kbqfe kbhotfixserver KB247568