How to Reset Autonum

Topic

New Reply

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

Reply | Quote

Replies

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

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.

Reply | 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.

Thanks for your explanation.
Armstrong

Reply | Quote