MDB corruption

[Paradigm]

I have an 81mb mdb file that has a corrupted record in it. A compact and
repair does not remove the corruption (also tried jetcomp). The record show
as #error in one of the fields. I can open the table and see the record but
when I try to delete it I get a 'the search key was not found in any record'
message and cannot delete the record.

I have tried exporting the table, importing it to another file and using vba
to try and copy the table record by record, in this case the routine crashes
about 10 records short of where the corruption is. The program seems to
still work in that new records can be added. Trying to edit the corrupted
record in the table directly gives a 'Invalid argument' error.

Unfortunately the file was used for sometime before the corruption was
recognised and all recent backups have the same problem.
Is there any other way that I could use to repair the file.
I have tried a /decompile but this is a backend table with no code, forms,
queries, reports, etc. and decompile had no effect.
Alex

 

[Arvin Meyer]

Just a WAG, but try this query:

SELECT * INTO NewTable
FROM OldTable
WHERE (((OldTable.ID) Not In (BadRecordID)));
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[John Vinson]

I have tried exporting the table, importing it to another file and using vba
to try and copy the table record by record, in this case the routine crashes
about 10 records short of where the corruption is. The program seems to
still work in that new records can be added. Trying to edit the corrupted
record in the table directly gives a 'Invalid argument' error.

If the Primary Key of the table is numeric, I'd suggest creating a new
empty database; import this table *design mode only*, no data. Import
everything else (you might have to drop relationships temporarily to
do this).

Use File... Get External Data... Link to link to the damaged database;
then run an Append query using the range of PK's from the beginning of
the database up to the record prior to this one, and from the next
good record to the end of the table.


John W. Vinson[MVP]