Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Why does my autonumbered field not start at 0?

Discussion in 'Information Technology' started by Laura, Nov 19, 2005.

  1. Laura

    Laura
    Expand Collapse
    Guest

    I have created a table and as all of the other fields could potentially have
    repeats I am using a numbered ID as the primary key, this however is not
    starting at zero it keeps starting at 22? Can anybody please help?
     
  2. Loading...

    Similar Threads Forum Date
    Buddhism Why Does Buddha Have A Jooda? Interfaith Dialogues Nov 29, 2014
    General Why does Caste still Persist with Sikhs? Hard Talk Jul 31, 2012
    General Why Does SPN Publish Third-Party Advertisement? Hard Talk Jul 15, 2011
    Why Interfaith Dialogue Doesn't Work - What We Can Do About It Interfaith Dialogues May 30, 2011
    Confucianism Who was Confucious and Why Does it Matter? Interfaith Dialogues May 23, 2011

  3. Al Camp

    Al Camp
    Expand Collapse
    Guest

    Laura,
    If your table is empty, before adding any records to your table...
    Compact the database.
    Then the first record you enter should be 1.
    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions

    "Laura" <Laura@discussions.microsoft.com> wrote in message
    news:CA2C72D4-EF25-40C7-A998-9ADC68E32156@microsoft.com...
    >I have created a table and as all of the other fields could potentially
    >have
    > repeats I am using a numbered ID as the primary key, this however is not
    > starting at zero it keeps starting at 22? Can anybody please help?
     
  4. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Laura

    If your Primary Key is used solely for identifying the record, does it
    matter whether it starts at 1 or 22 or 12345?

    Regards

    Jeff Boyce
    <Office/Access MVP>

    "Laura" <Laura@discussions.microsoft.com> wrote in message
    news:CA2C72D4-EF25-40C7-A998-9ADC68E32156@microsoft.com...
    >I have created a table and as all of the other fields could potentially
    >have
    > repeats I am using a numbered ID as the primary key, this however is not
    > starting at zero it keeps starting at 22? Can anybody please help?
     
  5. Larry Daugherty

    Larry Daugherty
    Expand Collapse
    Guest

    Hi Jeff,

    That's one reason for my frequent rant that Autonumber datatypes
    should absolutely, positively be used for nothing but surrogate keys
    and that they should never, never, never be seen by humans.

    --
    -Larry-
    --

    "Jeff Boyce" <nonsense@nonsense.com> wrote in message
    news:%2364hxLK7FHA.3416@TK2MSFTNGP15.phx.gbl...
    > Laura
    >
    > If your Primary Key is used solely for identifying the record, does

    it
    > matter whether it starts at 1 or 22 or 12345?
    >
    > Regards
    >
    > Jeff Boyce
    > <Office/Access MVP>
    >
    > "Laura" <Laura@discussions.microsoft.com> wrote in message
    > news:CA2C72D4-EF25-40C7-A998-9ADC68E32156@microsoft.com...
    > >I have created a table and as all of the other fields could

    potentially
    > >have
    > > repeats I am using a numbered ID as the primary key, this however

    is not
    > > starting at zero it keeps starting at 22? Can anybody please

    help?
    >
    >
     

Share This Page