Out of Memory loading vba

[Martin J]

Using Access 2000 fully updated on Win Me with 192mb of memory. Database
opens ok(with shift to make sure no programs are running) but when I try to
open visual basic it gives me out of memory errors. Everything in task
manager is closed. It has only been happening the last few days after I put
in some more code and forms/queries. My front end is 17mb it is attached to a
backend of about 120mb. I have repaired and compacted the database multiple
times and imported it in to a new one also.

Any other ideas besides get more memory?

 

[Robert Morley]

It seems unlikely that you're ACTUALLY out of memory. While 192 Meg may not
be HUGE by today's standards, I would think it would be enough to handle the
scenario you've described. You can always verify that with whatever
utilities ME has for checking memory availability (sorry, never used ME, and
it's been too many years since I've even used a 9x-based system). A few
things come to mind here:

First off, try decompiling your database. (If you're not familiar with it,
launch Access via a command line or the Start/Run dialogue, with your
database name in quotes, followed by "/decompile".)

Second, is it possible that some code is running at some point due to
hovering over a function name or something similar? If it is, then it could
be that the code has gotten into an infinite loop (errors in recursive
functions are famous for this).

Lastly, failing all else, as you've already done, try importing everything
into a new database, but do it in groups. All tables, then all queries,
then all forms, etc., testing the new database after each group. Once
you've narrowed down the group that causes the problem, try deleting the
entries in that group one-by-one and see if you can narrow down which one is
the problem (or absolute worst case, re-start the import process and only
import items in that group a few at a time).


Good luck,
Rob