Reset autonumber

  • Thread starter Thread starter Antonio Bustamante
  • Start date Start date
A

Antonio Bustamante

Some body can explain me How can reset autonumber field.
I apreciate yuor help
 
If you have deleted the records in the table .. then all you need to do
is compact the database to reset the Autonumber to 0.

HTH
RDH
 
Antonio

That will depend on which version of Access you are using. And it brings up
another question ... "Why?". What business need are you attempting to
satisfy by having an Autonumber reset to some starting value?

Autonumbers work great as rowID values, but are generally unfit for human
consumption.

Good luck

Jeff Boyce
<Access MVP>
 
You must log in or register to reply here.

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

new autonumber values already used in table 2
Add records number automatically 1
reset autonumber 5
Resetting a field property from text to Autonumber in Access 2002 3
New printer recommendations 2
autonumber field type 2
Continuing Autonumber from where I left off 9
autonumber 2

Back
Top