Results 1 to 3 of 3

Thread: autonum

  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: autonum

    How can I reset the auto number(data type)?
    I have entered sample data to a table. After deleting them from the table the new record that came up is the next record # of the last record deleted.

    Another word the record # continues to increment no matter what, it doesn't restart at Record #1.

    How can I fix it?

    Help, please

  2. #2
    Join Date
    Apr 2002
    Posts
    139
    Compacting the database should reset the autonumber field, if you have deleted all records.

  3. #3
    Join Date
    May 2002
    Posts
    395

    autonumber

    Thanks very much

Posting Permissions

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