Results 1 to 2 of 2

Thread: Autonumber Questiom...

  1. #1

    Thread Starter
    Member
    Join Date
    Jun 2000
    Posts
    34
    I was wondering if its possible to reset the autonumber in Access. the autonumber is getting really high because of testing purposes, I want to set it back to 1.

    Any ideas?
    Wick

  2. #2
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    It is possible (but I don't know how to do it, short of creating a new database and importing only the structures in). For testing purposes I usually start with a fresh DB (made from a copy) to avoid the problem you've encountered.

Posting Permissions

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



Click Here to Expand Forum to Full Width