Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Posts
    88

    Unanswered: Append Query Key Violations

    Maybe some fresh eyes will help.

    I have an append query that gets key violations and I'm not seeing why.

    I've tried the query with only the linked field present and I still get the violations.

    Can anyone take a look and help?

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Um ... And where is it????
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Oct 2002
    Posts
    88

    Key violations Append Query

    Here's the file. I guess I closed the window too soon the first time
    Attached Files Attached Files

  4. #4
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I couldn't open the database (probably wrong version of Access) but...

    The two things I would check, is the Primary Key being duplicated? Or is the Primary Key null? If the Primary Key is an Autonumber then leaving it null is OK, otherwise you have to provide a unique value.

  5. #5
    Join Date
    Oct 2002
    Posts
    88

    Key violations

    Try this one, It's Access 2000. I think the other attachment was wrong.

    It doesn't have duplicate values.

    The table that I want to get the records to amend from has about 700 unique ID field values (an automnumber) and the table to amend to has about 45 unique IDs. The linked field is the key field in this table. It is not an autonumber.

    I don't follow what part about leaving it null

    Thanks
    Attached Files Attached Files

Posting Permissions

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