Setting the auto number back to 1

S

SOrr

how do i set the auto number back to 1 for a new data
base. It keeps starting off at 221.
 
V

Van T. Dinh

Delete all Records in the Table and then do a Compact &
Repair of your database.

However, please not that the only purpose of AutoNumber
Field is to provide uniqueness to each Record in the Table
and the actual value allocated to each Record shouldn't
matter. In fact, users shouldn't even see the values of
the AutoNumber Field and the values can become random and
even negative.

If the actual values allocated are important to you, e.g.
sequential numbers, you should not use AutoNumber Field.

HTH
Van T. Dinh
MVP (Access)
 
E

Eric Cardenas

| how do i set the auto number back to 1 for a new data
| base. It keeps starting off at 221.
--------------
You would need to:

1. Delete all rows in the table.
2. Compact the database.

This will reset your autonumber to one.

Hope this helps,
 
Top