Microsoft KB Archive/279644

{|
 * width="100%"|

ACC97: Jet Compact Utility Available in Download Center

 * }

Q279644

-

The information in this article applies to:


 * Microsoft Access 97

-

Moderate: Requires basic macro, coding, and interoperability skills.

SUMMARY
The Jet compact utility, JETCOMP.exe, is a stand-alone utility that compacts databases created with Microsoft Jet database engine 3.x and 4.x. This utility may be run in conjunction with Microsoft Jet database engine 3.x and 4.x for recovering corrupted databases. Although you can run the Microsoft Access Compact utility or the CompactDatabase method with Microsoft Jet database engine 3.x and 4.x, Jetcomp.exe may be able to recover some databases that these utilities cannot. The reason for this is that 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 therefore be able to recover some databases that the Microsoft Access compact utility and the CompactDatabase method cannot.

NOTE: The user interface of JETCOMP.exe is in English only and is not supported by Microsoft Product Support Services. However, JETCOMP.exe can compact databases in any language supported by the Microsoft Jet database engine. JETCOMP.exe is a freely distributable utility, but requires that one of the following products is installed on the computer:


 * Microsoft Office 97
 * Microsoft Office 2000
 * Microsoft Access 97
 * Microsoft Access 2000
 * Microsoft Visual Basic 5.0
 * Microsoft Visual Basic 6.0
 * A Microsoft Office Developer Edition 97 run-time application that includes the run-time version of Microsoft Access 97
 * A Microsoft Office Developer 2000 run-time application that includes the run-time version of Microsoft Access 2000
 * A Microsoft Visual Basic 5.0 run-time application that includes Microsoft Jet database engine 3.5
 * A Microsoft Visual Basic 6.0 run-time application that includes Microsoft Jet database engine 3.5 or 4.0

The following file is available for download from the Microsoft Download Center:

"Download.gifoad JETCOMP.exe now]" 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.

MORE INFORMATION
The JetCU40.exe download contains the following files:

  JETCOMP.exe     The Jet Compact Utility JetComp.doc    A word document containing information about localization and support, instructions for use, errors encountered in earlier versions of Jet, MSysCompactError table, issues fixed by updated compact utility, and sample code to view rows containing modified column data Additional query words: JETCOMP exe inf JetCU40 exe

Keywords : kbfile kbdta

Issue type : kbhowto

Technology : kbAccessSearch