reset the autonumber ?

[saleemMSMS]

i designed a dtabase and few tables have autonumbers as primary keys. in the development process, i had to enter and manipulate the db with dummy data and now the autonumber has incremented to 25. eventhough i delete all the entries hoping the numbering will start from 1, it doesnt happen. instead it continues from 25.
is there any way to reset the autonumbers >?

 

[John Big Booty]

If there is no data in the table, then a Compact and Repair will reset the Auto Number to Zero.

However what number the Auto number starts should not matter ,as it should only be used to provide records with a unique identifier. If you need to create a sequential number you should use another method, as there is no guarantee that the Auto Number will provide this. I suggest you search this forum for more information on both these subjects.