[AccessD] Quirk in append query

If your source table is not filling in a required field in the
destination table, you can easily have this problem.  Since no records
are being appended, that would be the first place I would look.  Make
sure that all the fields you're trying to append should really be
appended and that any missing values are being handled corrected.  For
example, if you have a numeric field that is required and has a default
of zero, trying to append a null to it will cause problems because the
null will overwrite the default.

Charlotte Foust

-----Original Message-----
From: Garraway, Alun [mailto:Alun.Garraway at otto.de] 
Sent: Thursday, May 15, 2003 9:10 AM
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/accessd
Website: http://www.databaseadvisors.com