How to change the starting value of AutoNumber field?

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

--
Message posted via http://www.accessmonster.com

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"hkgary33 via AccessMonster.com" u23950@uwe wrote in message
news:64c340360c93a@uwe...
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.....)