Fsafdas

JetComp.exe Readme File

Table of Contents

Introduction 1

Localization and Support 1

Instructions 1

Errors Encountered in Earlier Versions of the Microsoft Jet Database Engine 2

MSysCompactError Table 3

Issues Fixed by Updated Compact Utility 4

Sample Code to View Rows Containing Modified Column Data 5

Introduction

This Readme file includes sample code that allows you to easily view rows of data in which the Jet database engine found problems during the Compact process. The Jet database engine generates an error if it encounters a problem during the Compact process and then creates the MSysCompactError table in the destination database. You can use Jetcomp.exe on secured databases and databases that have a database password.

Jetcomp.exe is a standalone utility that allows you to compact databases created with Microsoft Jet database engine 3.x and 4.x. This utility may be used in conjunction with Microsoft Jet database engine 3.x and 4.x 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.x and 4.x, 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. Jetcomp.exe is a freely distributable utility, but requires that you have one of the following products installed:

Microsoft Office 97

Microsoft Office 2000

Microsoft Access 97

Microsoft Access 2000

Microsoft Visual Basic®...