Corrupt Records

[Paula]

I have some corrupt records in my database, the data
displays in chinese (literally). I am unable to delete
these records, I am also unable to run a repair/compact
sucessfully. I have tried downloading JetComp but that
also fails. I get a -1017 (could not find field
description) error in MSysCompactError.

I'd be really appreciative if anyone can help.

 

[John Vinson]

I have some corrupt records in my database, the data
displays in chinese (literally). I am unable to delete
these records, I am also unable to run a repair/compact
sucessfully. I have tried downloading JetComp but that
also fails. I get a -1017 (could not find field
description) error in MSysCompactError.

I'd be really appreciative if anyone can help.

About the only solution here is to create a new .mdb file. Use File...
Get External Data... Import to import everything ELSE in the database
except for this table. Import this table but import it Design Only -
i.e. don't try to import the data, or it will import the corruption as
well.

Then use File... Get External Data... Link to link from the new
database to the damaged table. Create one or more Append queries using
criteria on the Primary Key to select all the records *except* the
damaged one; append this data to the new table. You'll need to
manually reenter the damaged record.

See http://www.granite.ab.ca/access/corruptmdbs.htm for additional
information and suggestions.