How to Reset Autonum

[armsys]

I have deleted a few records.
When adding a new record, Access automatically generates a new Autonum value sequentially by incrementing the last value regardless whether the corresponding records were already deleted. Is it a normal behavior of Access? Is it possible for Access to re-use the unused Autonum values.
Armstrong

[johnhutchison]

[quote name='armsys' post='772832' date='29-Apr-2009 20:23']I have deleted a few records.
When adding a new record, Access automatically generates a new Autonum value sequentially by incrementing the last value regardless whether the corresponding records were already deleted. Is it a normal behavior of Access? Is it possible for Access to re-use the unused Autonum values.
Armstrong[/quote]
Yes this is normal behaviour. To reset you need to delete all records then Compact and Repair.

If you don't like this behaviour, don't use autonumber. instead use a long Integer number field, and set its value yourself by finding the current maximum, then incrementing by 1.

[armsys]

[quote name='johnhutchison' post='772834' date='29-Apr-2009 17:27']Yes this is normal behaviour. To reset you need to delete all records then Compact and Repair.

If you don't like this behaviour, don't use autonumber. instead use a long Integer number field, and set its value yourself by finding the current maximum, then incrementing by 1.[/quote]
Thanks for your explanation.
Armstrong