Error 2004 - Out of memory occurs at Trace Point: 220
From Support
| If you have a question or seek clarification, please call Technical Support. |
Problem:
User is running Batch Report Server and they are getting error 2004 - out of memory error at trace point 220.
Solution:
1.) Read the following Microsoft Article for updating the Jet database engine. http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q172733
The Jet Database update can be downloaded from the RJS Web Site listed below as well: http://www.rjssoftware.com/files/jet35sp3.exe
The text of the Microsoft Article is listed below
ACC97: Updated Version of Microsoft Jet 3.5 Available for Download
The information in this article applies to: Microsoft Access 97
SUMMARY WARNING : To apply this service pack successfully, you need to have Microsoft Jet version 3.51.0623 or later installed on your computer. If your computer has an earlier version of Jet than this, you must upgrade your computer to Microsoft Office 97 Service Release 2 (SR-2). You can get information about Office 97 SR-2 and download the Office 97 SR-2 update from Tools on the Web at the following address:
http://office.microsoft.com/assistance/9798/sr2fact.aspx Failure to update your computer to the proper version of Jet may result in damage to your database products or may result in data corruption.
NOTE : Jet35sp3.exe (Microsoft Jet 3.5 Service Pack 3) replaces Jet35sp2.exe (Microsoft Jet 3.5 Service Pack 2), which is referenced on the Microsoft Office 97 SR-2 pages on Tools on the Web (http://office.microsoft.com/). Service Pack 2 and Service Pack 3 are both Year 2000-compliant; however, Service Pack 3 also includes additional security updates that are not available in Service Pack 2. If you have not yet installed Service Pack 2 or Service Pack 3, you should install Service Pack 3.
The Jet35sp3.exe file contains an update of several .dll files that are included with Microsoft Access 97, Microsoft Office 97 Professional Edition, Microsoft Visual Basic version 5.0 or later, and other products that incorporate Jet 3.5x. Microsoft Jet database engine version 3.51 provides an improved Compact utility that combines Compact and Repair into a single process. Also, the updated version of the Jet database engine generates an error if it encounters a problem during the Compact process, and then creates the table, MSysCompactError, in the destination database.
NOTE : Jetcomp.exe, which is included with Jet35sp3.exe, was updated on September 1, 1998. You can now use Jetcomp.exe on secured databases and databases that have a database password. Jet35sp3.exe now includes Jet 3.52 (MSjt4jlt.dll). Jet 3.52 only works with Jet's OLE DB provider and/or ADO going to Jet data via the Jet OLE DB provider. For additional information, see the following article in the Microsoft Knowledge Base: Q190463 What is MDAC, DA SDK, ODBC, OLE DB, ADO, RDS, ADO/MD? NOTE : Jetcomp.exe is a stand-alone utility that allows you to compact databases created with Microsoft Jet database engine 3.x. This utility may be used in conjunction with Microsoft Jet database engine 3.51 for recovering corrupted databases. Although it is possible to use the Microsoft Access Compact utility or the CompactDatabase method with Microsoft Jet database engine 3.51, Jetcomp.exe may be able to recover some databases that these utilities could not. This is because the Microsoft Access Compact utility and the CompactDatabase method attempt to open and close a database before attempting to compact it. In certain cases where these utilities may not be able to reopen the database, Compact will be unable to proceed, preventing recovery of the database. Jetcomp.exe does not attempt to open and close the database before compacting, and may be able to recover some databases that the Microsoft Access compact utility and the CompactDatabase method could not.
The user interface of JetComp.exe is in English only and is not supported by Microsoft Product Support Services. However, JetComp.exe can be used to compact databases in any language supported by the Microsoft Jet database engine. Jetcomp.exe is a freely distributable utility, but requires that you have one of the following products installed:
Microsoft Office 97
Microsoft Access 97
Microsoft Visual Basic 5.0
A Microsoft Office Developer Edition 97 run-time application that includes the run-time version of Microsoft Access 97
A Microsoft Visual Basic 5.0 run-time application that includes Microsoft Jet database engine 3.5
The following file is available for download from the Microsoft Download Center:
Jet35sp3.exe For additional information about how to download Microsoft Support files, click the article number below to view the article in the Microsoft Knowledge Base: Q119591 How to Obtain Microsoft Support Files from Online Services Microsoft used the most current virus detection software available on the date of posting to scan this file for viruses. Once posted, the file is housed on secure servers that prevent any unauthorized changes to the file.
NOTE : Jet35sp3.exe was updated on October 11, 1999. If you previously installed this update and would like to use the stricter security control provided in the updated Mstext35.dll, run the installed Mstext35.reg file. To run the Mstext35.reg file, locate the file on your system, and then double-click it.
The current release of Jet 3.5 SP3 contains the following files:
File Name Version Size -------------------------------------- JETCOMP.exe 1.0.1526.0 39,424 msexcl35.dll 3.51.3227.2 252,688 msjet35.dll 3.51.3328.0 1,050,896 msjt4jlt.dll 3.52.3328.0 1,238,288 msltus35.dll 3.51.3227.2 168,720 mspdox35.dll 3.51.3007.0 250,128 msrepl35.dll 3.51.3225.0 415,504 msrpfs35.dll 3.51.2826.0 44,304 mstext35.dll 3.51.3330.0 166,672
-and-
Jet35SP3.doc Installation instructions for the update and additional
information about the improved Compact utility
How to Install the Jet 3.5 Update Jet35SP3.exe is a self expanding archive that will expand the DLL files into the Windows\System folder. To completely install the Jet 3.5 Update, follow these steps: Ensure that you have Service Release 2 of Access or Office 97. To determine which service release you have, follow these steps.
Open Microsoft Access 97 and click Cancel when prompted to open a database.
On the Help menu, click About Microsoft Access .
The Service Release version will be listed directly below the product name and above the copyright information. If this line says "SR-1" or is missing completely, you will need to obtain the SR-2 update from Tools on the Web described in the "Summary" section of this article.
Download Jet35SP3.exe to any folder on your hard disk.
In Windows Explorer, double-click the Jet35SP3.exe file.
You may need to restart your computer for the changes to take effect.
MORE INFORMATION
The first release of Jet 3.5 SP3 contained the following files:
File Name Version Size -------------------------------------- Msjet35.dll 3.51.3203.0 1,050,384 Msrepl35.dll 3.51.3007.1 415,504 Msjt4jlt.dll 3.52.3203.0 1,238,800 Msexcl35.dll 3.51.2723.2 250,640 Mspdox35.dll 3.51.3007.0 250,128 Msrpfs35.dll 3.51.2826.0 44,304 Mstext35.dll 3.51.3203.0 166,672 Jetcomp.exe 1.0.1526.0 39,424
-and-
Jet35SP3.doc Installation instructions for the update and additional
information about the improved Compact utility
2.) Another cause of this problem could be that your server PC has more than 1.3 GB of memory. A few cases have been reported to Microsoft where a PC with more than this amount of memory has problems with the Jet database giving the error 2004 message.
