Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    3

    Unanswered: Autonumber sequence

    I imported data into a field, and the autonumber works fine from 1 to 80000, but when i append data to this table, the auto number jumps to 900000. How do I append data to a table so that i get a continuous autonumbering?

  2. #2
    Join Date
    Aug 2004
    Location
    Cary, NC
    Posts
    264
    Once an autonumber is used it will never be used again. They will go sequentially, but if you had 80,000 records and then deleted them, when you did another append, the autonumber would 80,001 and not 1.

    The only way you can get the autonumbers to start over (and honestly, there really isn't a need to) is to copy the table (choosing definition only) and then fix all the relationships to the new table.

    Steve.

Posting Permissions

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