Reset Auto Number

  • Thread starter Thread starter Jean
  • Start date Start date
J

Jean

Is their away to reset the Auto number back to one?
Every Time I run the query I need the table to delete and
repopulate with new data and the the first entry will
start at one again?

Is there a way to do that?
 
I know of two ways:

1) Delete all records from the table. Then compact the database.
2) Drop/delete the table. Then recreate it.

David
 
Why? Autonumbers are intended as unique row identifiers. Are you using
them for something else?
 

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

The next Grand Theft Auto title has been officially announced 0
Reset a auto number field 3
Access Sequentially numbered column that resets with each new sample 0
reset autonumber to '0' following delete query prior to appending 1
Need help in Auto number Please..!! 7
Access Auto Matching Duplicates? 0
How can I have the auto number field starts with 1? 3
How can I get a data and auto-number field to link? 1

Back
Top