Reset Auto number

[mrrherrera]

I have a form with the ID set as an auto number. I have entered test data to
make sure it's working. Now, after I delete the test data, the auto number
remembers the prior records and any new data is entered with the next number.
For example, if I enter two records and delete them. Then I enter a new
record, the number is four and not 1. Is there a way to reset the auto
number?

 

[mrrherrera]

I have a form with the ID set as an auto number. I have entered test data to
make sure it's working. Now, after I delete the test data, the auto number
remembers the prior records and any new data is entered with the next number.
For example, if I enter two records and delete them. Then I enter a new
record, the number is three and not 1. Is there a way to reset the auto
number?

 

[Mark A. Sam]

Yes, with no records in the table, simply compact and repair the database.

God Bless,

Mark A. Sam

 

[mrrherrera]

Thank you. I will try that.

Yes, with no records in the table, simply compact and repair the database.

God Bless,

Mark A. Sam

 

[Jeff Boyce]

Why do you care? The Access Autonumber is intended for use as a unique row
identifier. It is generally unfit for human consumption. Are you trying to
use it for a different purpose?

Regards

Jeff Boyce
Microsoft Office/Access MVP