How to reset Autonumber

[jGURU]

How can i reset the count/autonumber? During testing the Autonumber count reached 46, and now it continues from there. How can i make it go back to 1 and also continue from deleted records so if i delete number 46, it realizes that it should continue again from 46 and not 47?

Many thanks.

 

[saintsman]

In the table design view, copy your autonumber field, delete it and paste it back in. It will now start at one.

An autonumber will not know that you have deleted a record. You wouldn't want to have a whole series of numbers allocated which then would change if you deleted an earlier entry. Besides an autonumber entry is a unique number. It doesn't matter if it is in order as that number represents that entry.

 

[Fornatian]

Compacting and repairing the database will also reset an autonumber if the records are deleted. Saintsmans comments regarding viewing the Autonumber as simply a record bookmarking ID are entirely correct.