I don't need to reset the AutoNumber value like this question, but rather would like to first set the number to:
Which then increments like normal:
How do I go about doing this in Access 2010?
Although Access doesn't offer this function natively, it can be achieved through a query, like the following:
This will create a single table that's called "TableThatIncrements" with a single column, named "Id". You can now use the table editor to add properties and/or other columns.
to suit your needs, where
If you want to alter an existing table, use the following query. Make sure that specific table's tab is closed so Access can lock it down and alter it.
You can run a query in Access by doing the following:
You have to trick Access because it assumes you're not interested in an autonumber different than the one it provides.
You'll need to start the table out with the custom autonumber, which will require some setup. But once it's going you can just continue adding from there.
Google "access change autonumber start" and you'll find several options for doing this. Most rely on creating an append query to modify the field.
From MVPS.org: http://access.mvps.org/access/tables/tbl0005.htm
If you don't feel like building an append query, you could always set up the table and copy and paste 1000 lines of dummy data from excel, delete the records until you get to number 1001, and go on from there.
UPDATE: Adding explanation for reason
The reason behind autonumber being only set to start from 1 is that the autonumber field is meant to be used as an internal reference field, and in good database practice, should not generally be used in any publicly visible form. It is used in cases where there is not already a unique item in a given table to create a unique entry by which the table can be searched and indexed.