Resetting autonumber back to 1 (1 Viewer)

[stu_gnu]

Hi
I have created a form on which I have removed and then readded the autonumber tool for my ID field.
Unfortunately my ID fields now run from 8 to 27 instead of 1 to 19.
Is there any way of resetting the autonumber function so that my ID numbers run start from 1 again?

please help, thanks
Stu

 

[Carol]

You must remove the autonumber type from your field and then do a compile. Then you can add autonumber back as the field type and it will start back at one. But if you start any records or delete any, you will consistently have gaps within this field.

 

[Atomic Shrimp]

You've got to be a bit careful about resetting Autonumbers; they are provided only as a way of creating an unique reference to a row, nothing else (although they get used and abused for all sorts of other things).

You can reset the autonumbers in your table, but if you have another table that uses the autonumber as a foreign key, it will foul up your data integrity completely.