can I reuse deleted numbers in a primary key ID# field in Access?

D

diecastnut_1916

In my Access database I have had to delete about 20 records. I would like to
somehow reuse those numbers as I have photo files linked to the primary key
ID# that is automatically generated by Access.

Anyone who has an idea how to do this?

thnx
 
L

Larry Linson

No, autonumbers are intended to be "unique", and, except for a defect or two
over the years (now apparently corrected) not consecutive. They just hapen
to be consecutive in their simplest form, most of the time, if nothing
unusual happens.
 
Top