resetting autonumber to 0

[Guest]

I've been working with a database and the autonumber fields in all tables
have increased as I continue to add data to test the various functionality.
I'm ready to move it in to production but I want to reset all of the
autonumber fields back to 0 or 1.

The problem is I thought I saw something in "help" one time but I cannot
find it now. I found how to start the aotunumber at a diferent number (like
100) but that was for a new table and doesn't fit my situation.

I'd appreciate if someone can point me in the right direction. As always,
thanks for the help...

 

[Roger Carlson]

If you delete all the data from the table, then compact the database, the
Autonumber field should reset.

BUT you shouldn't care what this value is. If you do, you're using the
Autonumber incorrectly.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[BruceM]

If there are no records in the database, try compacting. You should do that
anyhow. Tools > Database Utitlites > Compact and Repair Database. Make a
copy first. However, you should know that if you need a sequential number,
autonumber is not the choice. Autonumber is for the database's use only,
and should not be visible to the user.

 

[Joseph Meehan]

I've been working with a database and the autonumber fields in all
tables have increased as I continue to add data to test the various
functionality. I'm ready to move it in to production but I want to
reset all of the autonumber fields back to 0 or 1.

The problem is I thought I saw something in "help" one time but I
cannot find it now. I found how to start the aotunumber at a
diferent number (like 100) but that was for a new table and doesn't
fit my situation.

I'd appreciate if someone can point me in the right direction. As
always, thanks for the help...

I suggest you may not want to use Autonumber for that use. Autonumbers
are designed to provide unique numbers. It in not designed to provide
numbers in order and for a number of reasons may not do so. As a result
using them in any application where the user sees the numbers is likely to
end up with confusion.

There are other ways of providing the numbers you want depending on the
particual application.