insert numbers / records in and autonumber data type

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mwdmanjg - 05 Jan 2005 18:43 GMT

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.

Reply to this Message

John Vinson - 05 Jan 2005 20:48 GMT

>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]

Reply to this Message