Results 1 to 3 of 3
  1. #1
    shashigk is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2009
    Posts
    2

    append query error

    I am able to view a append query in data sheet view but not able to run the querry:

    Microsoft Office Access set 0 field(s) to Null due to a type conversion failure, and it didn't add 6822 record(s) to the table due to key violations, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations.

    Please help
    thanks

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    A bit more information would be nice. What are you trying to append and what are you trying to append to?
    This is probably a violation against a primary key envolving dupliactes. You could post the db and someone could take a look for you.

  3. #3
    shashigk is offline Novice
    Windows Vista Access 2007
    Join Date
    Sep 2009
    Posts
    2

    append query error

    my challenge is i have 6 primary keys and it has 120 duplicates which I need to resolve before I can append the result. Still working on this..
    Thanks
    Sk

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

Similar Threads

  1. Replies: 1
    Last Post: 03-23-2010, 04:01 PM
  2. append, Key violation
    By klapheck in forum Queries
    Replies: 0
    Last Post: 09-17-2009, 11:50 AM
  3. Access append query
    By antoniorossano in forum Queries
    Replies: 1
    Last Post: 08-26-2009, 01:17 PM
  4. Replies: 2
    Last Post: 05-27-2009, 08:47 PM
  5. Query Error
    By zephaneas in forum Queries
    Replies: 0
    Last Post: 11-12-2008, 02:40 PM

Tags for this Thread

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