How to reset the Autonum field?

Discussion in 'MCAD' started by Nicolas Boucquey, Jan 4, 2004.

  1. I work with Access 2002. And I want to reset the Autonum
    field to deliver my application.
    How to reset the Autonum field?
    I tried with the method described in the Access Help
    pages. This method works fine to intialize the Autonum
    field to a greater value but not to reste the value to
    Zero.

    Many thanks in advance.

    Nicolas
    Nicolas Boucquey, Jan 4, 2004
    #1
    1. Advertising

  2. "Nicolas Boucquey" <> wrote in message news:<042a01c3d2b6$9daa4b50$>...
    > I work with Access 2002. And I want to reset the Autonum
    > field to deliver my application.
    > How to reset the Autonum field?
    > I tried with the method described in the Access Help
    > pages. This method works fine to intialize the Autonum
    > field to a greater value but not to reste the value to
    > Zero.
    >
    > Many thanks in advance.
    >
    > Nicolas


    If you purged all records from the table that has the autonumber,
    simply compact and repair the table. That will reset the autonumber.
    (easy fix!)

    Kael MCSD
    Kael V. Dowdy, Jan 5, 2004
    #2
    1. Advertising

  3. "Nicolas Boucquey" <> wrote in message news:<042a01c3d2b6$9daa4b50$>...
    > I work with Access 2002. And I want to reset the Autonum
    > field to deliver my application.
    > How to reset the Autonum field?
    > I tried with the method described in the Access Help
    > pages. This method works fine to intialize the Autonum
    > field to a greater value but not to reste the value to
    > Zero.
    >
    > Many thanks in advance.
    >
    > Nicolas


    Sorry, I meant "...compact and repair the database"
    Kael V. Dowdy, Jan 5, 2004
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Wai Kong [MSFT]

    Re: WPA-PSK field

    Wai Kong [MSFT], Jun 19, 2004, in forum: Wireless Networking
    Replies:
    0
    Views:
    1,935
    Wai Kong [MSFT]
    Jun 19, 2004
  2. =?Utf-8?B?RGVuaXMgSG9sdGthbXA=?=

    WPA-PSK Group Policy: No field to enter the PSK

    =?Utf-8?B?RGVuaXMgSG9sdGthbXA=?=, Sep 16, 2005, in forum: Wireless Networking
    Replies:
    0
    Views:
    1,184
    =?Utf-8?B?RGVuaXMgSG9sdGthbXA=?=
    Sep 16, 2005
  3. Jos Laarhoven

    date-field

    Jos Laarhoven, Nov 6, 2004, in forum: Firefox
    Replies:
    1
    Views:
    560
    Ranjit
    Nov 6, 2004
  4. Philipp Flesch
    Replies:
    3
    Views:
    4,717
    Philipp Flesch
    Jun 18, 2006
  5. jc
    Replies:
    0
    Views:
    1,502
Loading...

Share This Page