Results 1 to 2 of 2
  1. #1
    GMan7611 is offline Novice
    Windows XP Access 2002
    Join Date
    Oct 2012
    Posts
    1

    Key Violation when Attempting to Run an Appending Query

    I have MS Access 2010. I have not been able to determine why I get this message.



  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Not much to go on......

    Is the append query trying to append the PF field? Either 1) the PK field is an autonumber (can't append) or 2) appending the PK field would create a duplicate value. Try removing the PK field from the append query.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Append Query Key Violation
    By oleBucky in forum Queries
    Replies: 6
    Last Post: 12-05-2012, 03:55 PM
  2. Key Violation - APPEND Query
    By Al77 in forum Access
    Replies: 5
    Last Post: 02-21-2012, 11:10 PM
  3. Update some fields by appending query
    By lizzywu in forum Queries
    Replies: 7
    Last Post: 02-08-2012, 08:59 PM
  4. Replies: 3
    Last Post: 07-27-2011, 02:07 PM
  5. Key violation when appending records
    By slaterino in forum Programming
    Replies: 10
    Last Post: 08-26-2010, 08:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums