Hi,
There is a way to reset your autonumber to 1. However, you have to delete all of the records in any table that are related to the main table. Therefore it would be best if you backed up these tables!!!! Anyway, once you have backed up your table(s) delete all the records from the related tables. Then go to "Tools" - "Database Utilities" - "Compact and Repair Database..." Once it has done this your autonumber will be reset to zero! This only works in Access so if you are using Access as a front end to SQL or something else it won't work!!!! USE AT YOUR OWN RISK!!!!
jbehrne