Results 1 to 2 of 2

Thread: append query

  1. #1
    Join Date
    Jul 2004

    Unanswered: append query

    All, Using access 2003 frontend and sql server 2008 backend. I have an append query to insert 80000 from one table to an empty table. I get an error:

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

    I know this error normally comes if there are dups in a field that doesnt allow.

    I checked for duplicates and there are none. I can't seem to find the problem. Any ideas?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    My first guess would be that at least one of your early attempts was successful, so subsequent attempts after the successful attempt ought to fail.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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