Changing the starting value of an AutoNumber field

[michael_jacques]

Hi,

Does anyone know how to change the starting value of an autonumber field
from 1 to 110??

I am entering existing projects into my project table, however the project
codes start at 110. I am required to keep the existing project codes.

Any ideas?
Any help would be greatly appreciated.
Thanks, Michael

 

[Ken Snell [MVP]]

Create an append query to add one record to the table. Include the
autonumber field in the output field list, and set its value to one less
than the number you want the next record to get for the autonumber. Run the
query. Then you can add new records that will begin with the next autonumber
value. You then can delete the originally added record.

Note, autonumbers are not guaranteed to be consecutive, not to have gaps,
etc. If your records need an ID that has a specific, non-gap value, you
should not use autonumber type, and instead create your own values for a
Long Integer field for new records.

 

[peregenem]

Does anyone know how to change the starting value of an autonumber field
from 1 to 110??

http://support.microsoft.com/default.aspx?scid=kb;en-us;202121
ACC2000: Cannot Change Default Seed and Increment Value in UI

"you can use Data Definition Language (DDL) to create a table with an
Identity column [AutoNumber field] that has the seed and the increment
values that you want"

 

[Glynn]

I fear that you may be using the Autonumber for the wrong purpose.
Using the DMax() function can provide an incremental numbering sequence.
Once the DMax function is operating and you have the right beginning number -
then change the LOCKED Properties of the field to YES. The numbering
sequence is then locked in and cannot be changed except by unlocking the
field again.