Joined: 25 Jun 2004
Location: South Bend, Indiana USA
|Posted: Tue Jun 03, 2014 2:50 pm Post subject: Seed Auto Number in Access 2013
|If you want to start an autonumber with something other than 1 then you need to "seed" it with a number using SQL
Although Access doesn't offer this function natively, it can be achieved through a query, like the following:
CREATE TABLE TableThatIncrements
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 x is the initial increment number and y is the number to increment with. So AUTOINCREMENT(100,5) will yield: 100, 105, 110, 115, etc.
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.
ALTER TABLE TableThatIncrements
ALTER COLUMN Id AUTOINCREMENT(1001,1)