How to Overwrite instead of key-error for an APPEND-query???

[dirkg]

Hi all,<br><br>how can I make an APPEND-query overwrite already existing records instead of giving a key-violation-error because of duplicate keys found and leaving the (old) records in the table?<br><br>Thanks a lot in advance for your help!<br><br>Greetings,<br><br>Dirk<br><br><A HREF="mailto:dirk.news@yucom.be">dirk.news@yucom.be</A>

 

[DougP]

Well an Append query does just what it say's.<br>Append.<br>So even if you had no KEY errors it would append those records and you would have duplicates. I don't think that what you want either. <br>You need to use and Update Query to find and existing item and update it.<br><br>If you do want duplcates then open the table in Design view and Click on the &quot;Tools&quot; menu and &quot;Indexes&quot;<br>Find the Primary key and delete. Then look at the bototm and wher it says &quot;Indexed Yes (No Duplicates) change it to Indexed Yes (Duplicates OK)<br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.