How do I change the auto number to begin with the number I want?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create an auto number field that begins with a number other than
zero. I have followed the help instructions for an append query and it
changed only the first record. Each new record did not follow the new
numbering sequince.

Thanks for any help offered.

Michelle
 
Using ADOX, you can set the Seed and the Increment properties of the Column
in your Table in the Catalog.
 
Give it a try, Aaron.

From memory, you can assign the Increment when you CREATE TABLE, but I don't
think I ever tried to do it with an ALTER TABLE statement.
 
yeah i want to use it for BIGINTS where i have the first 5 digits 50805
-- aka the date.

so i want my PK for this huge table i've got to be 5080500000132431 or
something along those lines.. and then for tomorrow 508060000000000001

etc
 
Back
Top