Welcome to SPN

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

Sign Up Now!

Autonumber Reset problems

Discussion in 'Information Technology' started by Secret Squirrel, Nov 17, 2005.

  1. Secret Squirrel

    Secret Squirrel
    Expand Collapse
    Guest

    I am trying to reset my autonumber field back to a certain number but I can't
    seem to get it to work. When I reset it back using a computer with Win98 and
    Access 2000 it seems to work fine. But when I try and reset it back using
    WinXP and Access 2000 it won't reset. Does anyone know of any problems of
    this kind?
     
  2. Loading...

    Similar Threads Forum Date
    World Israeli bedouins fight resettlement plan Breaking News Aug 3, 2013
    Leisure Arcade scores have been reset Business, Lifestyle & Leisure Oct 7, 2005
    Sikh News BJP holds protest against Resettlement Act GK NEWS SERVICE (Greater Kashmir) Breaking News Apr 30, 2005

  3. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Secret Squirrel,

    What approach are you using to "reset" the Autonumber? In earlier
    versions of Access, compacting the database would reset an Autonumber's
    seed back to the highest number used +1, but in later versions this does
    not happen. However, in tables where *all* the records have been
    deleted, the Autonumber seed should be returned to 0 when the database
    is compacted.

    --
    Steve Schapel, Microsoft Access MVP


    Secret Squirrel wrote:
    > I am trying to reset my autonumber field back to a certain number but I can't
    > seem to get it to work. When I reset it back using a computer with Win98 and
    > Access 2000 it seems to work fine. But when I try and reset it back using
    > WinXP and Access 2000 it won't reset. Does anyone know of any problems of
    > this kind?
     
  4. Secret Squirrel

    Secret Squirrel
    Expand Collapse
    Guest

    Yep, tried that too. It seems kind of strange to me that it won't work on XP.

    "Ofer" wrote:

    > Did you try compact and repair on the mdb where the table is located in?
    > And not on the mdb that has a link to this table
    >
    > --
    > I hope that helped
    > Good Luck
    >
    >
    > "Secret Squirrel" wrote:
    >
    > > I am trying to reset my autonumber field back to a certain number but I can't
    > > seem to get it to work. When I reset it back using a computer with Win98 and
    > > Access 2000 it seems to work fine. But when I try and reset it back using
    > > WinXP and Access 2000 it won't reset. Does anyone know of any problems of
    > > this kind?
     
  5. Ofer

    Ofer
    Expand Collapse
    Guest

    Did you try compact and repair on the mdb where the table is located in?
    And not on the mdb that has a link to this table

    --
    I hope that helped
    Good Luck


    "Secret Squirrel" wrote:

    > I am trying to reset my autonumber field back to a certain number but I can't
    > seem to get it to work. When I reset it back using a computer with Win98 and
    > Access 2000 it seems to work fine. But when I try and reset it back using
    > WinXP and Access 2000 it won't reset. Does anyone know of any problems of
    > this kind?
     

Share This Page