Results 1 to 4 of 4

Thread: Autonumber

  1. #1
    Join Date
    Nov 2004
    Posts
    5

    Unanswered: Autonumber

    hi all, i am using an autonumber to number my records. but when i delete the records the number does not reset to "0" but continues. is there anyway to solve this problem?? thanks

  2. #2
    Join Date
    Mar 2004
    Location
    Oakland, CA, USA
    Posts
    26
    Hello saranwho,

    Delete the autonumber field and re-create it. Don't forget to take note any relationship that you may need to reestablish at a later time.

  3. #3
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    Here is a link to the Microsoft KnowledgeBase that gives you several ways to do it. http://support.microsoft.com/default...b;en-us;812718
    However, in the past I have been able to reset the number after deleting the records by running Compact and Repair under the Tools menu. I have read that there is a known bug (or 'feature' ) in Access 2002 and 2003 that causes this not to work (MS Article ID 287756).

    TD

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    why do you want to reset the number field. I can understand iof you are shipping a new system and want to let the client see it start from 1 but if its an internally used number does it matter. For a one off the earlier respondants are right. If you want toi leave data in place delete the indexes, realtionships etc then then column, then re-create the column, indexes & relationships. If you want to satrt with null data, then delete all the data, remove the primary key, change the column type to long integer, save , then changed the column type to autonumber
    HTH

Posting Permissions

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