Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    121

    Unanswered: Re-setting Autonumber

    Hello,
    I have a table whose primary key is set to autonumber. I've removed all the records from the table, however, my autonumber primary key field is still has not reset to 1.

    I know that compacting the db after I cleared all the records is supposed to re-set the autonumber to begin at 1 again, but this appearantly only works when all the records in ALL the tables have been deleted,. i.e. I only want to reset the autonumber in only one of my tables.

    Any thought?

    TM

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Re-setting Autonumber

    Originally posted by tmalone
    Hello,
    I have a table whose primary key is set to autonumber. I've removed all the records from the table, however, my autonumber primary key field is still has not reset to 1.

    I know that compacting the db after I cleared all the records is supposed to re-set the autonumber to begin at 1 again, but this appearantly only works when all the records in ALL the tables have been deleted,. i.e. I only want to reset the autonumber in only one of my tables.

    Any thought?

    TM
    Copy the structure to another tablename, delete the old table and rename the new one ...

  3. #3
    Join Date
    Aug 2002
    Posts
    121
    hank you.. much appreciated

Posting Permissions

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