Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auto number curiosity (XP SP 1)

    I appended approximately 700 records to a table with an autonumber field (called ID) as the primary key (previously there were 5 records in this table, using numbers 1 - 5, which had been deleted)

    Can anyone explain where the autonumbers generated started at 453054268??

    This isn't really important as I was just testing something but I have never seen anything like this before. It just struck me as being a bit odd.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Auto number curiosity (XP SP 1)

    You may have somehow set the sequence to random - check the field properties for that table. You should be able to reset the autonumber so it begins with 1 by setting it to the normal value, and doing a compact/repair.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto number curiosity (XP SP 1)

    Nope, its just set to increment, all the new records are numbered sequentially, they just start at the most abnormally large number

    Anyway, nothing to lose sleep over, I'll be deleting the table and it will probably never happen to me again <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •