I have a question about append queries:
When I run an append query somtimes I get message that some records couse key violation or not meet the validation rules but I can't find which records!
When I copy data to a table, if there is a problem with keys or validation rules Access generates Paste Errors table which shows the records that cause the problem.
Can I get something similar with append queries so that I can find those "problem" records!
Thak you in advance!