Why every time my Access Database Autonum field never shows me 1,2,3....?

[Paul]

I just built an Access Database and set the 1st column as Autonum fields. It
starts with 1, 2, 3 at the begining, however after I deleted all
records(total 5 records) and add new records, the new one didn't start with
1, 2, 3 as it should be. Insteadly it starts with 6, 7, 8. Does anyone know
how to let my database automatically set my first record's autonum field
back to 1, I don't want see 6 or 7 at the beginning of my table.Thank you!

The Best Regards
Paul

 

[Kevin3NF]

Autonumber is not guaranteed to be sequential, just unique. If you need
sequential numbers that will be seen by your users, create a number field
and increment it by one for each new record.

 

[Slim]

Try "Compacting and Repairing" the database under database utilities.