I would like to go into my existing database and reset the auto number to 0 and start the over again from the beginning i.e. 1.2,3,4 etc. How can I do that?
You can delete all data in the table, then Tools, Database Utilities, Compact and Repair. This may set the first record Autonumber to 1. Be aware that autonumber is usually used for a primary key (unique value) in a table. If this is the case, it doesn't matter what value the autonumber is.
However, if it does not work, there is another way, viewable <<
here >>
If you really need to have the first record start at 0, you can create a new field, say "NEW_ID", and make an expression Auto_ID - 1 in an update query.
abach
1728 Posts
92
0
Posted April 10th, 2007 15:00