On May 7, 5:22*am, "Derek" wrote:
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