RE: 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 would start by letting it append those that it will and then run an unmatch
query to see what was not appended.
Use input table left join to new table with criteria for new table join
field as 'Is Null'.

First look for nulls.
Then duplicate records.

--
KARL DEWEY
Build a little - Test a little


"JN" wrote:

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: Membership database updates
    ... When you open any Query in Design View, click on the toolbar just next to ... black down-arrow where you can change your query to an Append or Update ... If you have any current members in your Import list, ... You mention Update Queries and Append Queries but I can't find how to ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Assign macro on After update event
    ... I don't see why you can't append the current record next scheduled date to ... it then try using an update query to update the dates in the new record. ... "Anna" wrote: ... maybe you can help me with that: all this macro is ...
    (microsoft.public.access.forms)
  • Re: duplicates query help & strategy for update queries with SetWarnings = False
    ... I have many many queries that check for orpaned data (for example, if there's a billing record with no matching custID in the customer table, I'm putting up a form with the unmatched data, and a quick way to update all unmatched to one archive type customer, etc. ... I was surprised to see duplicate entries in some of the static tables for dropdown selections, so I have to solve this one now. ... Once the user has handled all the problems, you enable the final command button at the bottom of the form, which executes an append query to add the data to the real table. ...
    (comp.databases.ms-access)
  • Re: Append Query Date Criteria Problem.
    ... Why can't I append some records? ... Choose Parameters on the Query menu. ... Access opens the paramters dialog. ... > End Sub ...
    (microsoft.public.access.queries)
  • RE: How to use Append Queries to add new records
    ... I sort of knew how the append query would work, ... > destination field name that you want to append those values to. ... > out new action queries. ...
    (microsoft.public.access.queries)