CORRUPTION???

[Derek]

Hi all

If you have a corrupt record somewhere in a data table, how do you
find/eliminate it?

My tables have relationships on key fields that are autonumbers. I believe
that this will make creating new tables a nightmare as auto numbers would
reset on recreation.

Help!!

 

[John W. Vinson]

My tables have relationships on key fields that are autonumbers. I believe
that this will make creating new tables a nightmare as auto numbers would
reset on recreation.

What you can do is create the new table (in a new .mdb file!), empty, and run
an Append query from the linked corrupted table. The existing autonumber
values will be copied into the new table.

Just be sure that the append query omits any reference WHATSOEVER to the
corrupt record. For instance, if you ascertain that the record with autonumber
ID 3124 is corrupt, use a query with criteria like

<= 3123 AND >= 3125

so that you never "touch" the corrupt record.

 

[Alan]

Hi all

If you have acorruptrecord somewhere in a data table, how do you
find/eliminate it?

My tables have relationships on key fields that are autonumbers. I believe
that this will make creating new tables a nightmare as auto numbers would
reset on recreation.

Help!!

Hi,

You may also try to recover your file. You can try a tool called
Advanced Access Repair at http://www.datanumen.com/aar/ This tool is
rather useful in salvaging damaged Access MDB files. Hope this helps.

Alan