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 table view of the main table to select the fields.
Select the required Sort …