On Tue, 6 May 2008 22:22:44 +0100, "Derek" wrote:

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

John W. Vinson [MVP]