I have an existing update query that replaces nominated fields in one table with that of another. The query is now failing with an "error 3167 record deleted" message because a handful of the records referenced in the source table have been deleted in the destination table.



Is there a way I can configure the query to "skip" missing records and just update those that it finds rather than failing the whole query?

Many thanks for any assistance you can provide.