Reset AutoNumber

  • Thread starter Thread starter Asha
  • Start date Start date
A

Asha

I have designed a table which has one AutoNumber field.
During development I have entered few test data and the
Autonumber field kept incrementing by 1. Now the database
is ready so i deleted the test data and I want to enter
the actual data. When i try to enter the first record the
autonumber field does not start at 1 but starts at 6
because I had 5 test data which i deleted.

Does anyone know how I can reset the Autonumber field so
that it starts from 1 again.

thanks
 
If I remember correctly once the table is empty run compact and repair that
should reset the autonumber
 
good question I'd like to know too...especially when
imbedding subforms that need to increment the records
 
I think it's a mistake to ever care what value an autonumber contains. It's
sole purpose should be to provide a unique primary key. Nothing more,
nothing less.
 
Back
Top