Error 2004

[Manu888]

Hello good
I have been installing a warehouse management program that works correctly on Windows XP/95. When installing it in Windows 7 there are no problems, but when running it it gives the following error:

"Runtime error '2004' occurred: not enough memory"

This program uses an Access 2000 database with .mbd files and I think the error is probably there.

As if it didn't recognize the amount of memory (hard drive does recognize it without problems)
Windows has an option to run programs on other older Windows to avoid some compatibility errors. I have tried it with Windows 95 and XP, which are the ones where I know it works and nothing.

Does anyone know a solution

 

[dhookom]

I assume you have considered upgrading to supported Access and Windows versions.

 

[lameid]

Not sure how you are installing it.

However MSACCESS.EXE has bloated in size over the years and the bigger it gets the less left over memory in a 2 GB addressable 32 bit memory space there is.

For me running 64 bit office is the only thing to reliably solve memory issues. There are things that may help like setting processor affinity to a single core and other things but 64 bit is the answer. I am assuming you are not running in Access 2000? You are talking about versions of software that are out of support and have been for sometime. Closing down object variables explicitly helps too.

And while I would recommend staying away from Office 365 automatic channel updates from my recent experiences, the later versions in general are good and stable. (Office 365 I have concerns about enough testing being done).

Also Office still seems to be optimized for single core execution. Turning Hyperthreading off in your bios MAY make it run faster if it is doing a lot of things. It does for what I am doing. There is of course a lot of performance benefit elsewhere to having it on so this a choice of balance. This also means your performance will be more closely related to thinking about specs in old ways. Processor clock speed and FSB Clock Speed are key metrics. A faster processor according to someone may mean at parallel processing which Office is not doing yet.


But Duane is right, you really ought to be on updated software.... at least somewhat recent versions as well as 64 bit version of office. Good Luck.