HowTo: Change the Autonumber start value and increment in MS Access

http://support.microsoft.com/kb/202121/

Here was a problem that was perplexing us with MS Access. You can only have an autonumber field begin at one. The attached MS Support site shows you how to get around it. Basically, JET has an IDENTITY() operator used in its CREATE TABLE function that takes parameters on the seed (first value) and the increment amount.

Whilst a bit late for my current uni assignment, I will be sure to implement this in part 2.

Leave a Reply