Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004

    Unanswered: problem with primary key


    recently i transposed a few tables into one. This is a table with personal information. The primary key is the [ID] field. But now I have a problem with the autonumbering in that field. A new record automatically gets the number 720, but there already is a record with that number. Now i can't save any new records anymore!

    Any solutions?


  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Bring up your Access help, type in Autonumber. Select "See More" then click on "Change the starting value of an incrementing AutoNumber field." This gives the ins and out of doing just that, for an empty table or for one that already contains data.

    Hope this helps!
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Careful with this. Anytime you go around proposing to change primary keys you better make sure there isn't any dependant data in other tables that's about to be orphaned or worse, assigned to a different entity.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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