troubleshooting Question

ACC97: 2004 Out of Memory Error Message

Avatar of tpigielski
tpigielski asked on
Microsoft Access
2 Comments1 Solution1479 ViewsLast Modified:
I have a VB3 application, built upon Access 97, that was running fine on a Windows 2000 Professional box.  We upgraded memory on the box from 1 GB to 2 GB, and now the application gives the "Out of Memory" error message, which is a known bug published by Microsoft.

According to the Microsoft KB, the following was documented related to this problem:
===============================================================

ACC97: "2004: Out of Memory" Error when Running Query
View products that this article applies to.
Article ID : 191743
Last Review : October 20, 2003
Revision : 1.0
This article was previously published under Q191743
Advanced: Requires expert coding, interoperability, and multiuser skills.
SYMPTOMS
When you run a query, you may receive the following error message when memory is still available:
2004 'Out of Memory.'
You may also receive the error message:
Query too complex.
 Back to the top

CAUSE
You have a newer version of the Microsoft Jet database engine than the one originally installed by your Microsoft product. When you use Microsoft Data Access Objects (DAO) code to get data from a Jet database, you may see this problem if you are doing the following:
• Using code to loop through a recordset based on a linked table.  
• Working with a QueryDef  
The error has been reported to occur in the following languages: Visual Basic and Visual C++ (using MFC), and with the DAO Software Development Kit. This problem is related to the Jet database engine itself, not to DAO.
 Back to the top

RESOLUTION
NOTE: You should first verify that you have not actually run out of memory and that your Temp folder (directory) is set to a valid folder and is not full. If neither of these conditions is true, you may be experiencing this problem.

To resolve this problem, do one of the following: 1. Obtain and install the Microsoft Office 97 Service Release 2. For more information about getting this Service Release, see the following article in the Microsoft Knowledge Base:
151261 (http://support.microsoft.com/kb/151261/EN-US/) OFF97: How to Obtain and Install MS Office 97 SR-2  
2. Obtain Jet35sp3.exe from the Microsoft Web site; this file contains the updated version 3.51 of the Microsoft Jet database engine. For information on how to obtain Microsoft Jet 3.51, please see the following article in the Microsoft Knowledge Base:
172733 (http://support.microsoft.com/kb/172733/EN-US/) ACC97: Updated Version of Microsoft Jet 3.5 Available for Download  

==========================================================================

Unfortunately, when we apply this suggested fix, the problem does not go away, we still get the same error message.  Would anyone have any ideas of what else we could do or look for?

Thanks...Tom
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros