Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data recovery

Status
Not open for further replies.

Moss100

Technical User
Aug 10, 2004
586
GB
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top