I run a lot of append queries in my database application.
Many times, I get a message that a certain number of records were not appended due to key violations or referential violations. When I hit okay, all it does is append records. I have no idea of knowing which records were not appended. Is there any "Error Report" to see which records were unappendable