Replace Autonumber(ed) record

[PaulW]

My user, in his infinite wisdom, after many warnings about why he should not delete records, has seen fit to have someone on his staff delete records where the autonumber field is used as a foreign key.

I have the records in a backup of my data.mdb, is there any way I can import only some records from the old mdb into the current mdb to get those autonumbered records "restored"?

TIA

[HansV]

If you create an append query and include the AutoNumber field, you can add the records from the backup table to the production table while preserving the AutoNumber values.

BTW, if you set Enforce Referential Integrity for a relationship, users won't be able to delete "parent" records as long as there are "child" records, so that it's impossible to leave "orphans".

S0134.png

[PaulW]

Hans,

Again thank you so much. I did not use referential integrity because I didn't trust Access 2003 when I wrote the system.