I have an append query which, when run, says it can not append the records due to key violations. However, if i turn it into a select query and manually copy the records from the query into the table where i want it appended it works fine.

Is there any reason why this could be happening?

Thank you

Dont worry - I had an ID field which was an auto number, and it didnt like the old one being copied in. Removing this field fixed it.