Compacting database

[Guest]

I can't compact a database the allowed me to compact before. It keeps giving me record(s) can't be read error. I have done everything that article 301869 has suggested. Does anyone have any idea? Your help would be greatly appreciated.

 

[John Boatner, MCSD, MCDBA, MCSE, MCSA, MCDST]

Hi Anthony:

The outlook may be grim. That error is indicative of corruption in the
system tables and file structure of the .mdb. The best I can suggest is to
create a new database and attempt to import the objects from the old
database file.

Also, here are a couple more articles that you may find useful:

ACC97: How to Repair a Damaged Jet 3.5 Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;279334

ACC: Microsoft Jet Utilities Available in Download Center
http://support.microsoft.com/default.aspx?scid=kb;EN-US;176670

ACC: Jet Database Engine 3.x Error Messages Due to Corruption
http://support.microsoft.com/default.aspx?scid=kb;EN-US;182867

Good luck.

--

Regards,

John Boatner
MCSD, MCDBA, MCSE, MCSA, MCDST
J2 Technologies, Inc.
http://www.j2tech.com

I can't compact a database the allowed me to compact before. It keeps

giving me record(s) can't be read error. I have done everything that
article 301869 has suggested. Does anyone have any idea? Your help would
be greatly appreciated.