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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto fill not working 2
How do you add auto number system to existing form in access? 2
Auto Populate Field 1
New record problem in sub-form 5
The next Grand Theft Auto title has been officially announced 0
forms, junction tables, and many-to-many relationships 1
Automatically highlight duplicate value 1
Auto load fields in form 4

Back
Top