Sometimes these are not obvious to find. These may help track it down.
1. Is your append query trying to assign values to the primary key field?
Could that be the source of the duplicate?
2. Do you have any other fields that are "Indexed: No Duplicates"? Any
compound indexes?
3. Is the query assigning values to a field that is a foreign key to another
table? Is it possible that these values do not match the values in that
other table?
4. Is there a validation rule on the table itself (i.e. in the Properties
box in table design view, as opposed to the Validation Rule for a field,
which shows in the lower pane of the table design window)?
5. Does the query attempt to assign a string with no characters in it (as
opposed to a Null value) to a text field that has its Allow Zero Length
property set to No?
6. Is there an Default Value in one of the fields that is NOT being assigned
by the query? For example, a foreign key with zero as the Default Value?
7. Is there data that is outside the range a field can accept, e.g. an
integer larger than 32767, or a Null to a Yes/No field?
8. Is one of the query fields arriving in a format that Access is not
understanding, e.g. for a date, or for a currency?
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reply to group, rather than allenbrowne at mvps dot org.
warbler said:
I'm trying to append an access table to another access table, and I
received the following error "Microsoft Access...didn't add 8657 records due
to validation rule violations". I've checked and double-checked: my 2 tables
have identical designs - fields types, widths, and neither have any
validation rules or validation text set. Any ideas what the problem is and
how to overcome it?
