Hello,
Today my database corrupted.
My table called TblProperty corrupted and reported a record that I was editing as ‘deleted’.
Sure enough when I check the record in the table the autonumber was blank and many cells just contained hashes.
I tried compact and repair, but no joy.
I had a backup from last night, so I had two options.
1. Restore the table from last nights backup and re-enter todays changes again (which is what i did)
Or
2. Delete the corrupted record and insert the record again from the back up table.
What is the best approach to this? Also how would I go about reinserting the record with the correct autonumber Id. Can I use an append query, and if so will it copy over the original autonumber ID from my back up table?
Alternatively, is there another approach?
Many thanks
Mark.
Today my database corrupted.
My table called TblProperty corrupted and reported a record that I was editing as ‘deleted’.
Sure enough when I check the record in the table the autonumber was blank and many cells just contained hashes.
I tried compact and repair, but no joy.
I had a backup from last night, so I had two options.
1. Restore the table from last nights backup and re-enter todays changes again (which is what i did)
Or
2. Delete the corrupted record and insert the record again from the back up table.
What is the best approach to this? Also how would I go about reinserting the record with the correct autonumber Id. Can I use an append query, and if so will it copy over the original autonumber ID from my back up table?
Alternatively, is there another approach?
Many thanks
Mark.