Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Data recovery

Data recovery

Data recovery


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)


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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close