-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|