Results 1 to 2 of 2

Thread: Autonumber

  1. #1
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78

    Unanswered: Autonumber

    I have used the standard conversion utility to convert an Access 2 database to Access 2000. When new records are entered into the tables the autonumber column does not do to the next number but use a big minus number eg -275639.

    With out createing a new ID autonumber column and starting from 1 how can I get the next record to go to the next correct number eg from 100100 to 100101?

    Neil.

  2. #2
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78
    Oh nevermid i've actually answered my own question. Please ignore.

Posting Permissions

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