I have an adodb command that is running an append query. The first time you run the query the values to be appended are all new and don't violate the key of the receiving table. When I run the query again after adding a few new records to the source table, I get a key violation (as I should), but the whole query stops. It does not append only the new records as I would like it to. If you run the same query via Docmd.RunSql, it appends only the new records. What do I have to do to get the ADODB Command Append query to bypass the error and append only the new records?