<html><div style='background-color:'><DIV>
<P>sometimes, a way to get a better idea of what is going on is to open the table you want to append from and cut and paste the records (in test db of course) to the table you are appending to. The errors will get put into the Paste Errors table - then you can inspect the records in Paste Errors and try to debug it.<BR>Cheesy but effective.</P>
<P>_d<BR></P></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Garraway, Alun" <ALUN.GARRAWAY@OTTO.DE>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: "Access DatabaseAdvisors (E-Mail)" <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: [AccessD] Quirk in append query
<DIV></DIV>>Date: Thu, 15 May 2003 19:09:30 +0200
<DIV></DIV>>
<DIV></DIV>>hallo I'm new to the list and have a problem,
<DIV></DIV>>
<DIV></DIV>>I have an append query the table with data that I'm trying to append hass
<DIV></DIV>>19933 records.
<DIV></DIV>>the table to which I want to append to contains 18657 with a PK set to no
<DIV></DIV>>duplicates.
<DIV></DIV>>
<DIV></DIV>>that means the query *should* append 1276 new records, but when I run the
<DIV></DIV>>query,
<DIV></DIV>>I get the warning from Access, due to PK etc 19933 records could not be
<DIV></DIV>>appended =:-O
<DIV></DIV>>
<DIV></DIV>>does anybody have a "cure" for this illness?
<DIV></DIV>>
<DIV></DIV>>using A2K with NT Network
<DIV></DIV>>
<DIV></DIV>>TIA
<DIV></DIV>>alun
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Alun Garraway
<DIV></DIV>>IM-IT Sonderprojekte LBB-ET-D1
<DIV></DIV>>Tel. (040) 64 61 5573
<DIV></DIV>>Fax (040) 64 64 5573
<DIV></DIV>>mailto:alun.garraway@otto.de
<DIV></DIV>>
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>Tired of spam? Get <a href="http://g.msn.com/8HMNENUS/2734??PS=">advanced junk mail protection</a> with MSN 8.</html>