Error Compacting 97 Database

[chuckdfoster]

I am getting errors while trying to compact an Access 97 database. I am
getting an error that says

"The Microsoft Jet database engine could not find the object
'MSysCompactError'. Make sure the object exists and that you spell its
name and the path name correctly."

I have tried creating that object and making its fields ErrorCode (int),
ErrorDescription(memo), ErrorRecID(Binary) and ErrorTable(Text(64)). I
found that info on the MS website. This does not work; I still get the
"could not find" error.

Anyone know why this is happening or know how to fix this problem?

Thanks, Chuck Foster

 

[Randy Balbuena]

I am getting errors while trying to compact an Access 97 database. I am
getting an error that says

"The Microsoft Jet database engine could not find the object
'MSysCompactError'. Make sure the object exists and that you spell
its
name and the path name correctly."

I have tried creating that object and making its fields ErrorCode (int),
ErrorDescription(memo), ErrorRecID(Binary) and ErrorTable(Text(64)). I
found that info on the MS website. This does not work; I still get the
"could not find" error.

Anyone know why this is happening or know how to fix this problem?

Thanks, Chuck Foster

Chuck,

As it seems, your database is corrupted.

The table MSysCompactError contains information regarding errors Access
found during the Compact process. If there are errors listed it normally
indicates the database is badly corrupted and a backup should be used. The
Repair process truncates and trash the damaged portions of a file.

When the MSysCompactErrors table is produced, it indicates what portions of
the file were truncated due to corruption. In almost every case this data
could have truly been recovered if the Repair tool had not been utilized.
That's why is so important to have regular backups of database (specially
before using Compact and Repair).

I don't know if it is too late to try (or if you haven't already done so),
but make a backup and try to repair the file by using the "JetComp.exe"
utility. If this fails then you should try a data rescue service, who can
usually repair the file, but there is always the possibility that the
database is damaged beyond repair. Please read the Microsoft resolution
about the issue at:
http://support.microsoft.com/?kbid=273956

ACC97: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/?kbid=306829

 

[Tony Toews]

I am getting errors while trying to compact an Access 97 database. I am
getting an error that says

"The Microsoft Jet database engine could not find the object
'MSysCompactError'. Make sure the object exists and that you spell its
name and the path name correctly."

I'd suggest making a backup of that MDB immediately. Randy has given
you one suggestion. Another one would be to try importing from that
MDB. There are a number of other suggestions and more information on
corruption including possible causes, determining the offending PC,
retrieving your data, links, official MS KB articles and a list of
vendors who state they can fix corruption see the Microsoft Access
Corruption FAQ at http://www.granite.ab.ca/access/corruptmdbs.htm

Once (or if) you've managed to recover the data I'd suggest reloading
a backup of the MDB and comparing the number of records in all the
tables to see if things look "normal".

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm