how do I change the starting value for an autonumber field in access 2007

(...)
> how do I change the starting value for an autonumber field in access 2007

DoCmd.RunSQL "alter table Table1 alter column ID counter(X,1)"

X - starting value

K.P.

"Richard" wrote:

> how do I change the starting value for an autonumber field in access 2007

How exactly do I do that? Where do I enter that line? Sorry for my ignorance!

"Krzysztof Pozorek [MVP]" wrote:

> (...)
> > how do I change the starting value for an autonumber field in access 2007
> 
> DoCmd.RunSQL "alter table Table1 alter column ID counter(X,1)"
> 
> X - starting value
> 
> K.P.
> 
> 
> 

You may use it in a query:
alter table Table1 alter column ID counter(1,1)

or in VBA code (module, immediate window):
DoCmd.RunSQL "alter table Table1 alter column ID counter(1,1)"

K.P. MVP, Poland
www.access.vis.pl


(...)
> How exactly do I do that? Where do I enter that line? Sorry for my 
> ignorance!
>
> "Krzysztof Pozorek [MVP]" wrote:
>
>> (...)
>> > how do I change the starting value for an autonumber field in access 
>> > 2007
>>
>> DoCmd.RunSQL "alter table Table1 alter column ID counter(X,1)"
>>
>> X - starting value
>>
>> K.P.
>>
>>
>>