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

P

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
 
K

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.
 

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

Autonum, but not? :S 6
fill treeview with records from database 15
Addressing items in tables with similar functions, but dissimilar fields 3
Entering data in new tables & want to 'see' related data 4
Text File input Manipulation with ACCESS 1
Double quotes within text cause unparsable record error 2
Looping through a table's records and changing, then resorting 0
Number Fields in Access 2007 Database 1

Top