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>
 
Back
Top