Reset Auto number

  • Thread starter Thread starter mrrherrera
  • Start date Start date
M

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 said:
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?
Click to expand...
 
Yes, with no records in the table, simply compact and repair the database.

God Bless,

Mark A. Sam
 
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
 
Back
Top