Why do I get "out of Memory" message running Access2000 in XP

[Guest]

Hello,
I have simmilar problem as posted two days ago. Mr. Jeff Conrad replied the
question.
But I'm running Access2000 on XP (Ms office 2000 Pro) and the same msg
appears.

There isn't enough memory available to perform this calculation.
Close unneeded programs etc..

This msg apeares when running macro loop with repeat expresion that runs it
many times.

I have 768Mb RAM
MS JET.dll version is 3.51.2723.0

Do I need to install some latest JET service pack?

 

[Douglas J Steele]

How much space do you have on your hard drive (specifically, the drive
pointed to by your TEMP environment variable)? Access often dumps temporary
files out there, and you'll get that error message in those circumstances.

By the way, Access 2000 doesn't use Jet 3.5x: it uses Jet 4.0 (which is DAO
3.6)

 

[aaron.kempf]

tell us what you're trying to do

i have gotten that message on Access 97 with 2gb ram and a MDB that is
only 3mb

-aaron

 

[Guest]

I found solution. I made mistake running action Paste in macro loop. Paste
action followed action .[SelLength] in a string so that just a part of string
was changed with pasted one. Loop run more that 11000 times.
It seems like copy, paste, delete macro actions have limited space amount.
I replaced action Paste with SetValue (Right([ ];([ ]![Len]-[ ])) action and
the problem disapeared.

There are both Msjet35.dll and MS40.dll (4.00.8618.0) files on
Windows/system32 on my computer. Reference Microsoft DAO 3.6 Object Library
is activated and database is compiled OK.