Autonumber - starting at a specific number

[Lori]

Is there a way when I setup a table with an autonumber
field, that I can specify that I would like it to start at
a specific number. I want the numbers generated
incrementally, which I have set in the table design, but
would like them to start at 100 instead of 1, which
appears to be the default. I am using Access 97. Thanks

 

[Allen Browne]

If you import a record with the autonumber 99 and then delete it, the
numbers will start at 100.

Details:
Set AutoNumbers to start from ...
at:
http://allenbrowne.com/ser-26.html