How to change the starting value of AutoNumber field?

[hkgary33 via AccessMonster.com]

Dear all,
I've searched and read the Access Help file about this question but I still
don't understand how to solve it. For example, in my database, I have a table
named tblFileInfo and it have a AutoNumber field named FileNo (also set as
Primary key to link with other tables). And the "New Values" Property of this
field is set to "Increment". Now, my database is blank, how should I amend in
the property of this field so that the starting value is not from 1? (say, if
I want to start the value from 10000,10001,10002.....)

Thanks a lot!!!!!

Gary

 

[Allen Browne]

Use an Append query to write the value one less than you want to the table.

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