ACC2000: Error Message: "There Isn't Enough Memory Available to Perform This Calculation"

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.

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.

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:

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.