Reset AutoNumber Values

Step-by-Step

1. Open the desired Table in Datasheet view.

2. Click Edit on the menu bar and choose Reset AutoNumber. This will bring up the Reset AutoNumber window.

3. Select the AutoNumber field you wish to reset from the dropdown of fields available in the Table. You can apply the reset to only new records or to all existing records.

4. You can define a new Starting value if you wish.