Corrupted record in autonumber field

[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!

 

[Allen Browne]

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;