restore a deleted record in table with autonumber field

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

I need to restore a deleted record into a table that has an autonumber field.
The autonumber field is also the primary key, so It's imperative that the
number in the autonumber field is exactly what it used to be. I know this
can be done, but I need help. Thanks
 
If you have the information then do a compact & repair. Close the database.
Open the database and append data including the number to the autonumber
field.
 
Use an Append Query to append the new record (and old autonumber
value) to the table.

If you have a FE/BE split database, open the BE to run the Append
Query, to avoid resetting / corrupting your next autonumber.

(david)
 
Back
Top