Out of Memory errors Using Access 2003 SP3

[Michaniker]

Ever since I installed Office SP3, my Access databases corrupt during
development giving an Out of Memory Error. Sometimes I have to replace a form
that won't open and sometimes I have to replace the whole database and
redevelop. The work around is to reboot every 15 minutes during development.
This is getting old. Does anyone understand why this is occuring and how to
fix it?

 

[Paul Shapiro]

There is a post-SP3 hotfix available, discussed in KB 945674. I also had
some corruption issues in a few forms. I was able to fix them by deleting
the problematic forms and re-importing working versions of the form from an
older copy of the db.

I use SourceSafe integration, and I think something in that process is
sometimes corrupting forms and/or reports during Access version changes. I
had a similar issue with a db developed in Access 2003 SP2 that was then
corrupting in Access 2007. In that case I was able to reproduce the problem
and trace it to the SourceSafe integration. An MS tech support engineer was
also able to reproduce the problem. He came up with a workaround of opening
every form in the older Access version before ever trying to open the db in
the newer Access version. Once the original corruption issues were repaired,
that seems to "reliably" prevent the problem.

It's well worth reading through the tips on Allen Browne's website:
http://allenbrowne.com/tips.html.