Auto number ID

Results 1 to 4 of 4

Thread: Auto number ID

  1. #1
    John D Guest

    Default Auto number ID

    Does anyone know if or how to start the auto number ID in an Access database at a particular number rather than 1?<BR><BR>TIA

  2. #2
    Eddie Campbell Guest

    Default RE: Auto number ID

    Don&#039;t think you can, but why would you want to ?

  3. #3
    Eddie Campbell Guest

    Default Actually... there IS a way

    If you append a row to the table AND supply a value for the Autonumber Id, it will be created (as long as it is higher than the last used ID).<BR><BR>Your autonumbering will now carry on from that number.

  4. #4
    Join Date
    Dec 1969

    Default RE: Auto number ID

    I think you need to insert some data up to the number you like.<BR>Then delete them and start a new one from the number you got.

Posting Permissions

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