resetting autonumber to 0

J

JT

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...
 
B

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.
 
Top