Results 1 to 2 of 2

Thread: Autonumber

  1. #1
    Join Date
    Dec 1969

    Default Autonumber

    Hi,<BR>I had deleted some records from my table which has a auonumber field. Does anybody know how to reset the number in Autonumber field? Is it Possible in Access 2000?<BR><BR>Thanks in advance.

  2. #2
    MG Guest

    Default RE: Autonumber

    1. Copy the table<BR>2. Paste the table as a new name "structure only"<BR>3. Write a query to append the data from the origonal table to the new table. Do not append the autonumber field.<BR>4. Rename the origonal table as table_old. <BR>5. Rename the new table the name of the original table.

Posting Permissions

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