Record Corruption problem

[johnL]

Working in Access 2002. Periodically getting corruption
that causes the unique IDNo (which is an auto number,
primary key, long integer, incremental) to change from
its current 3 figure number to an apparently random huge
number. Most other number fields also get corrupted (eg
currency gets changed from say £5 to billions of pounds!)

It is possible to delete and recreate the record, however
the Unique IDNo starts from the new huge number + one, as
expected. Although this is OK in one way, it is inelegant
and I would rather identify the root cause of the
problem. Simply copying the whole table into another new
table (without the corrupt record) cannot work for us as
there is another linked table which usues the unique IDNo
as the link (ie each record in the corrupted table needs
to keep its original Unique IDNo)

Any suggestions on how to stop this corruption gratefuly
received!

 

[Steve Schapel]

John,

You could get the records into a new table while ensuring the existing
autonumber values are preserved, by using an Append Query.

As for why it's happening, I imagine this would not be easy to track
down. But something here may help...
http://www.granite.ab.ca/access/corruptmdbs.htm