Reset AutoNumber

[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

 

[RobFMS]

Asha

After deleting all the records, you should do a Compact & Repair.

HTH

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Need to launch your application in the appropriate version of Access?
http://www.fmsinc.com/Products/startup/index.asp

Need software tools for Access, VB, SQL or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Gina Whipp]

If I remember correctly once the table is empty run compact and repair that
should reset the autonumber

 

[Boyd]

good question I'd like to know too...especially when
imbedding subforms that need to increment the records

 

[Duane Hookom]

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.