I am trying to append data from one table to another in Access . The destination table has some validation rule imposed in some of the columns, I want when the append query fails due to validation for some particular records then i want to copy that record to a different table and that filed should be highlight in that table so user can rectify the bad data.
How to do this??
Any suggestions??