How do I reset autonumber field in access 2003?
Use the "compact and repair" process. This will reset the auto increment back to 0 (for empty tables that is). If the table is still populated with records you don't want to reset the counter i think...
It can be found under: Tools >> Database Utilities >> Compact and Repair Database
A quick "totu" here with few ways to reset it. From Microsoft KB:
http://support.microsoft.com/kb/812718
"I can't paste it here since it's in french for me"... sorry!