AutoNumber primary keys and deleting records

A

Almine

When I delete records from a table using autonumber as the primary key, do
the autonumbers from the deleted records become available for the table to
use again?
 
M

Melinda

Hi Almine,
No, the autonumbers from the deleted records will not be reused. The
autonumber just keeps on numbering and does not know when records disappear.
Hope that helps,
Melinda
 
Top