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

    Unanswered: problem with primary key

    Hello

    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?

    Thanks!!

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    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 foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    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
  •