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