Restart Autonumber

D

DSmith

Is it possible to re-start an autonumber field with "1" after all the data
has been deleted?
 
K

Ken Snell [MVP]

Yes. Compact the database after you've deleted all the records from the
table.
 

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
Autonumber field in Excel that behaves the same as Access 0
Visio Utilizing 100% Memory - Troubleshooting 0
Unable to display values in 2nd list box from 1st list box selection 2
Autonumber records inserted in gaps 0
Re-number an Autonumber 4
comparing table values 1
Create My own Autonumber 6

Top