Does anyone know the best way of creating a error log table containing records that have failed to append to a target table for reasons of validation? I think this must be done using vba code to loop through the source table records appending each one in turn to either the target table or to the error log table as appropriate.

thanks

im not sure, but i thought access has an error log table already, theyre just hidden