[AccessD] Quirk in append query

Alun,

The error message said how many were PK violations, how many were
datatype violations, etc.  You need to look at each type of reported
problem and solve each.  If you do not understand what one of the
reported problem types is, we will be glad to try to explain it if you
give us all the information.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Garraway, Alun [mailto:Alun.Garraway at otto.de] 
Sent: Thursday 2003 May 15 12:10
To: Access DatabaseAdvisors (E-Mail)
Subject: [AccessD] Quirk in append query

hallo I'm new to the list and have a problem,

I have an append query the table with data that I'm trying to append
hass 19933 records. the table to which I want to append to contains
18657 with a PK set to no duplicates.

that means the query *should* append 1276 new records, but when I run
the query, I get the warning from Access, due to PK etc 19933 records
could not be appended =:-O

does anybody have a "cure" for this illness?

using A2K with NT Network

TIA
alun



Alun Garraway
IM-IT Sonderprojekte LBB-ET-D1
Tel. (040) 64 61 5573
Fax (040) 64 64 5573
mailto:alun.garraway at otto.de