insert numbers / records in and autonumber data type

[Guest]

I have my main key for a table set to autonumber, and the first record
comming up is 3 instead of 1, how can i reset my counter back to 1 for the
autonumber field in the table, Thanks in advance.

 

[John Vinson]

I have my main key for a table set to autonumber, and the first record
comming up is 3 instead of 1, how can i reset my counter back to 1 for the
autonumber field in the table, Thanks in advance.

Depends on your version of Access - try using Tools... Database
Utilities... Compact and Repair Database.

However, Autonumbers should NOT be used if the value in the autonumber
field is of any importance other than for linking tables. They will
*always* have gaps, and can become random. If you'll be showing these
values to users, it's best not to use an Autonumber field AT ALL;
instead use a Long Integer field and maintain it manually or with some
simple VBA code as a Custom Counter.

John W. Vinson[MVP]