💻 Software
How do I set the first value of AutoNumber in Access?
Fresh5 days ago
Mar 15, 2026162290 viewsConfidence Score0%
0%
Problem
I don't need to reset the AutoNumber value like this question, but rather would like to first set the number to: 1001 Which then increments like normal: 1001 1002 1003 ... How do I go about doing this in Access 2010?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: How do I set the first value of AutoNumber in Access?
Low Risk
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 a…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix