I need some help understanding how to allocate page files or something memory related that is preventing my rather large MS Access application from compiling.
Symptoms: After adding a small amount of new VBA code, I try to compile and get "Out of Memory" error. The VBA editor highlights some code in my reports, which are the last objects added when I import them to build out a new development file.
I've tried shrinking the application, but even after pulling out old objects or obsolete modules, I'm still getting this error which is hampering the development process. I'm developing on a 3 yr old Dell Precision M6600 16GB ram, Windows 7 SP1, dual 2.3 Ghz processors (8 cores) and 45 GB of available hard drive space. I've recently defragged the drive, and Windows is handling page file settings.
Any help figuring out the root cause of this error would be greatly appreciated.