How to Reset Autonumber in Access 2003

if you want to reset the data type autonumber in microsoft access 2003 and you do not how to do it. it is easy. just follow these steps.

you can see the autonumber does not 1 anymore if you delete all records so autonumber will continue counting not reset to 1 again.

if we want to reset the autonumber. we should delete all record in this table first.

after we delete all records then we compact and repair database. this step will reset autonumber back to 1

after we compact and repair database. then we check the table and we try to input data. it will reset to number 1.