Hi

Am at the end of my knowledge!

I am getting the dreaded "key violations" message on an Append query - every single record on the input table is rejected.

I have checked all the indexes on the target table and they are all OK.

Does anyone have any ideas? Its amazing how many hits you get surfing but I havent found one that works for me.

This is so simple - no VBA, no macro --- just a simple append query of a few fields on the input data to a large master table

Any ideas very welcome

Regards

Tony Randell