Figuring out what field is causing key violation on append

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a new version of a program. It has pretty much the same table
design, except for a couple of extra fields and a few fields got an
increased in size.

I want to just copy my data from my old table into the table in the new DB
(SQL 2000 back end) however when I do I get the error:

Microsoft Office Access can't append all the records in the append query
Microsof Office set......and did not add XX records to the table due to key
violations, .......(all other than key violations is 0)

This table has about 75 fields. A lot of them in the previous version were
set to Required = No and other minor changes. It would take for every to
find the right combination so is there a way when I run an append query to
see what field(s) is causing the problem?




.

Relevant Pages

  • Re: Figuring out what field is causing key violation on append
    ... First try the query with just one field in the append query. ... Microsoft Office Access can't append all the records in the append query ... .......(all other than key violations is 0) ...
    (microsoft.public.access.queries)
  • Re: Figuring out what field is causing key violation on append
    ... First try the query with just one field in the append query. ... Microsoft Office Access can't append all the records in the append query ... .......(all other than key violations is 0) ...
    (microsoft.public.access.queries)
  • Re: Figuring out what field is causing key violation on append
    ... The problem is NO records append. ... Microsoft Office Access can't append all the records in the append query ... .......(all other than key violations is 0) ...
    (microsoft.public.access.queries)
  • Re: REMOVING DUPLICATES
    ... due to key violations, 0 records due to loc violation, and 0 records ... to remove duplicates in 97 but can in 00 or 03 please let me know. ... create an append query from old table to new table. ...
    (microsoft.public.access.gettingstarted)
  • INSERT INTO / Key Violation
    ... When I use the code below in an AfterUpdate event on a form, ... stating that the Append query "didn't add 1 recorddue to key violations." ...
    (microsoft.public.access.formscoding)