I keep receiving 'Key Violation' warning messages when trying to append data from one Table to another. This is despite NOT attempting to include / append the ID field of the donor table.
After reading through some Forum entries I decided to try removing the Primary Key designation on the ID fields of the receiving Table and it now seems to work!
This is not, however, acceptable because I NEED the ID in the recipient Table to be designated as a Primary Key. It does not work when 'no duplicates' are specified in the ID fields properties either. Unique ID's are, however, crucial here.
Surely this is not an 'acceptable' bug?
Any clues?
Thanks
Al