Corrupted record in autonumber field

  • Thread starter Thread starter Dan Barnes
  • Start date Start date
D

Dan Barnes

Our database recently corrupted and we successfully
repaired it except one record was lost. We need to
restore that record exactly but the autonumber field won't
let us input the original value. Is there a way to
manually restore the original value in this field?

Thanks in advance for your help!
 
Use an append query to stuff the values into the fields.

This example adds a record to the table "tblClient" where the ClientID
(autonumber field) is 8:

INSERT INTO tblClient ( ClientNum, Surname, FirstName )
SELECT 8 AS ClientID, "Barnes" AS Surname, "Dan" AS FirstName;
 
Back
Top