In MS Access I am trying to append data from one table to another table that is identical. However, once I run the append query, I get a message telling me that "..it didn't add 2253 rows due to key violations". How can I identify the 2253 records that are causing the key violations?
Many thanks,
Delon.
do a query on which records in either table have the same keys... something like "select t1.id from t1, t2 where t1.id in (select t2.id from t2)" (mind that this isn't the most efficient of queries, you really want a join there, or an exists).
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.