Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Location
    Ann Arbor, MI
    Posts
    47

    Angry Unanswered: Auto Number Blues

    Hi Everyone, thanks for viewing...

    I recently split a database using the wizard. One of my Tables has an auto-number field for the key. I had changed it to an Auto-Number from a text field some time ago using an append query. When I split the database last night, the Autonumber field was at 24222. Now it gives me 26112 as the next number.

    I copied the structure of the table to a new table.
    erased the the 26112 record in the source table.
    appended all records from source table to new table.
    when I add a new record to the new table, I get 26113. I expected 24223.

    My problem is that after splitting the database, the autonumber field sequence has jumped to 26112 from 24222. Why? And is there a way back?

    thanks!

  2. #2
    Join Date
    Dec 2002
    Posts
    60

    Re: Auto Number Blues

    I don't know why it jumped to 26112, but try deleting all records after 24222 then compacting. Next record should be 24223

  3. #3
    Join Date
    Sep 2002
    Location
    Ann Arbor, MI
    Posts
    47
    That done it ... thanks

Posting Permissions

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