Out of memory error in access

[bsquared]

I keep getting "Out of memory" error messages when I try to execute or modify
the visual basic scripts in an access database. I can manipulate tables and
run queries, but the application will not let me run or modify scripts. The
problem is not script-specific: I can't delete or add even a single character
in any of my scripts without getting this error message. I have plenty of
RAM, and other Access applications run fine, so this appears to be a problem
specific to this application. Application compacts successfully to 83 MB
(nowhere near maximum database size), and VB references are OK. Does anyone
have an idea what might be causing this, and how I might fix it?

 

[Howard Woods]

Do you have any exits (usually a close exit) that may be running as a result
of you trying to edit / run a script?
I am not expert in how to get past the problem, but could you have some VB
that either directly or indirectly calls itself, and could get into a deadly
embrace loop? Perhaps you could put a breakpoint or two in the VB, just to
see if anything like that is happening?
Nothing like a good bug hunt!