"There isn't enough memory..."

[MK]

On two different Access 2007 database, now, since moving to Win7 a couple of
months ago, I open the database and get, "There isn't enough memory to
perform this operation..." I do VBA coding in both of these, but the coding
worked fine before Win7. Any relation? How do I get past this, short of
having to rebuild the databases by importing all components into a new one,
each time. I have upwards of 10 databases!

 

[Allen Browne]

Unless you are actually opening too many things at once (within the
database, or in other programs as well), the message indicates a corruption
of the form. This is not uncommon where you have used multiple versions of
Access.

You may be able to solve it with a decompile, followed by a compact and
recompile. Alternatively, it may require exporting the form with SaveAsText,
deleting, compacting, and importing it again with LoadFromText.

Details on recovering from corruption:
http://allenbrowne.com/recover.html