Out of Memory VBA

[Doug]

I know a lot of people have posted similar problems to
this but I haven't found an identical one, and I still
don't have a solution.
Whenever any VBA script runs in my Access database I get
an "Out of Memory" message. The same thing happens when I
try to edit VBA - the actual editing is fine until I try
to move on to a different line and I get the message. The
number of editor windows I have open makes no difference.
It happens with only one open, and it lets me open as many
more windows as I want without a problem until I edit. I
can open as many external apps as I want without a problem
too.
After reading various other posts I've tried importing
objects into another (new) database. So far I've had
absolutely no problem when importing tables (dozens of
them), but can receive an "out of memory" message
importing the first form into an empty database. This
isn't entirely consistent though - sometimes it happens,
sometimes it doesn't.
Any ideas welcomed, cos I'm starting to think I'm going to
spend days getting nowhere on this.
Thanks,
Doug

 

[gandalf]

your database is probably corrupt

take a backup first and stock it away safely
then read http://www.granite.ab.ca/access/corruptmdbs.htm

if it is only 1 form I would try to rebuild it.