Reset Auto Number

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?
 
G

GreySky

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
 
J

Jeff Boyce

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