But if you want your autonumber field to start at 1 then you could just delete your current autonumber field and then put it back in again. That renumbered the autonumber field for me.

Retrieving SQL Server Identity Column Values When working with Microsoft SQL Server, you can create a stored procedure with an output parameter to return the identity value for an inserted row. The ...

Makers can now create and edit Autonumber fields in the entity field designer UI. Previously this functionality was only exposed through the API, but we have now brought it to the UI for easier use.

I have a fairly large MS Access database (6,000 records or so) across several tables. Recently something went wrong when compacting or something odd happened, the short of it is that the ID field ...

However, we occasionally want to start the AutoNumber at a number higher than 1. To do this, create an Append query to insert the value of the ID one less than your desired starting number (or Seed ...