[AccessD] Quirk in append query

Welcome to the list Alun

IIRC the Access error says something about "index errors", not
specifically PK ones. Are you sure you hven't got another index which is
preventing these records appending?

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Garraway, Alun
> Sent: 15 May 2003 18: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
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>