Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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?
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page