Reset Auto Number

[Guest]

I finish a database with some tables and several reports. I create lots of
items in the tables to test everything and now I'm ready to distribute the
database. But I would really like to reset the auto number to begin in 1
again. I delete all the data in the table but the next number is still a
different than 1 number.

Can you help me please?

 

[BruceM]

I believe that if you delete the field and then re-create it you will start
again at 1, but you would first need to break any relationships, then
re-establish them. Autonumber is for the database's purpose only. You
should not be using it for anything such as a tracking number or invoice
number or whatever. There is no need to reset it. Any time you go to a new
record the autonumber is assigned, whether or not you actually create a
record. There are practical reasons for this. If you are interested in
learning more you could do a groups search for "autonumber reset" or
something to that effect. The topic is frequently discussed.
If you are looking for an incremented number, check out the following link:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb
Watch for line wrapping in the link. You could also try a groups search for
"incremented number" or something like that. Post back if you have more
questions.

 

[fredg]

I finish a database with some tables and several reports. I create lots of
items in the tables to test everything and now I'm ready to distribute the
database. But I would really like to reset the auto number to begin in 1
again. I delete all the data in the table but the next number is still a
different than 1 number.

Can you help me please?

There is no real need to, however if you want to, simply delete all
the data in the tables, (NOT the tables themselves).
Then Compact the database Tools + Database Utilities + Compact.

All the autonumber fields will reset to 1.