re-setting autonumber

Results 1 to 2 of 2

Thread: re-setting autonumber

  1. #1
    John A Scholl Guest

    Default re-setting autonumber

    Is there a way to reset an autonumber field to 1 after writing to<BR>and then emptying a table. I tried the procedure outlined in<BR>Access97 Help but it only works if the new starting number is<BR>greater than the previous ending number.

  2. #2
    Join Date
    Dec 1969

    Default RE: re-setting autonumber

    Go to tools in Access and select compact and repair. That will start the sequence over.

Posting Permissions

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