This MS Access tutorial explains how to to reset autonumber in Access 2007.
To reset autonumber in Microsoft Office Access 2007, follow these steps:
Delete the AutoNumber field from the main table.
Click the Create tab, and then choose Query Design.
In the Show Table dialog box, select the main table. Click Add, and then Close.
Double-click the required fields in the [...]