21 January 2010

There isn't enough memory to perform this operation

I usually use MS-Access to program, and I got the following message:
There isn't enough memory to perform this operation. Close unneeded programs and try the operation later.
When I tried to open a certain form (in design view or in form view).

Needless to say, I closed all the programs available (including my messenger) and it didn't help much.

The reason was: too much IIF() in the text boxes of the form. Access had problems loading it.
The solution: Copy the form from the backup.
Move all the IIF required to the back end (in my case: the underlying SQL view).
Now the form loads up quickly and correctly!
Moral of the story: don't use too much IIF().

No comments:

Post a Comment