Append query key violations
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
Append Query Key Violations
Hi
The full msg is attached as a screen shot.
The input table does not supply any key as the object table has an Autonumber key.
Regards
Tony Randell