Reset autonumber

A

Antonio Bustamante

Some body can explain me How can reset autonumber field.
I apreciate yuor help
 
R

R. Hicks

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
 
J

Jeff Boyce

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>
 

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
WIERD GLITCHED/ERROR IMAGE HELP APRECIATED! 1
Autonumber field in Excel that behaves the same as Access 0
Missing fonts after computer reset 3
VBA - (re-) Set a Table Style 2
You'll need a new app to open this about link 1
Excel VBA to delete records in Access table and reset the Autonumber 1
Unable to display values in 2nd list box from 1st list box selection 2

Top