[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