Memory leak?

[Lars Brownie]

In my Access 2002 main form, when I perform a Ctrl-F search on a memo field,
I sometimes get the message:

"There isn't enough memory to perform this operation. close unneeded
programs and try the operation again"

When I close the app and reopen it, it works fine again. Can someone tell me
what the problem is and how I can prevent it from happening? I found some
internet messages but not the one I was hoping for.

Thanks, Lars

 

[david]

Compact and repair the database: look at the memo's to see if any
are corrupted.

A memory message is normally a generic message that something
failed: it is often the only message that is provided, and just means
that all code failures are assumed to be memory allocation errors.

(david)

 

[Lars Brownie]

Thanks David.

The error occures in the front end, so from what you're saying I understand
the problem might lie in the back end and I should perform the compact
repair on the back end?

 

[david]

Yes, compact and repair the back end.

If it doesn't fix the problem, at least it was easy and got rid
of the most likely cause.

(david)