Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820

    Unanswered: Reset the autonumber

    i want a nice simple counter 1 to what ever in a table but this table isn't permanent and after i delete the content i want the auto number to reset to 1 can it be done?
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  2. #2
    Join Date
    Oct 2002
    Location
    UK
    Posts
    21

    Re: Reset the autonumber

    the easiest way I've found is to copy and paste the table (structure only as "table copy" or similar) then delete the old one and rename the new one to the original name.

  3. #3
    Join Date
    Oct 2002
    Location
    UK
    Posts
    21

    Re: Reset the autonumber

    If you compact a database ("Compact and Repair" from the "Tools","Database Utilites" menu) then any EMPTY tables have their Autonumber fields reset to 1 too.

  4. #4
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    i'll try it, thx
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

Posting Permissions

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