CORRUPTION???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Derek - 06 May 2008 22:22 GMT

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!!

Reply to this Message

John W. Vinson - 07 May 2008 17:13 GMT

>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.

Signature

John W. Vinson [MVP]

Reply to this Message

Alan - 11 May 2008 15:17 GMT

> Hi all
>
[quoted text clipped - 6 lines]
>
> 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

Reply to this Message