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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
primary key - concatenated or autonumber? 6
How can I Manually Change Access Primary Key ID Fields ? 2
restore a deleted record in table with autonumber field 2
Autonumber Drastic Increase 4
Autonumber trying to create duplicates 3
sqlite-odbc write conflict 2
Primary Keys yes or no? 8

Top