"Isn't enough memory" error. Can't be rid of it.

[RoadKyng]

Evidently I changed something that Access 2003 didn't like. I am getting the
memory error on every launch. I have individually opened every table, report,
query and form and don't get any errors. I have compacted and repaired
several times. To no avail. This pops right after the database opens. I
disabled the initial menu and it still pops up. After I clear it I see no
errors, so it is a nuisance issue. However I don't want to deploy this rev of
the database with the error.

Anyone have any troubleshooting tips?

 

[Jim Burke in Novi]

I would try a decompile. Every now and then I get some strange errors, and so
far I've always been able to fix them with a compact/repair, decompile, and
then another compact/repair. To decompile you need to run the following
command in command (DOS) mode:

"C:\Program FIles\Microsoft Office\Office\MSAccess.exe" /Decompile
"your fully qualified access file name here"

There's a space after '/Decompile' - this is splitting it up into a new line.
You may need to change the location of the access library name, depending on
what you have installed on your machine. I keep a shortcut to a bat file on
my desktop with the decompile command in it, and whenever I need to do one I
edit that file, put in the appropriate file name, then save and run it.