If you start a brand new table and enter in 5 rows of data (Column 1 being the autonumber). Then, if you delete those 5 rows of data, your autonumber will be starting out at #6. Is there a way to reset that autonumber so it starts back at 1?

Yes empty the table and do a "compact and repair" this will reset any autonumber

JR

Thank you! I found your suggestion in the help files.
Tools > Database Utilities > Compact and Repair

Does the entire database have to be empty?

Yes and no only empty tables will the autonumber be reset. So If you want to reset all autonumbers so yes emty the tables which has autonumbers in them.

JR

See this link (http://support.microsoft.com/kb/812718) for more info on resetting an Autonumber

Much appreciated!