Append Query- Key Violation

[jprochelle]

I am doing an append query. When I run it, the data shows up in datasheet view. but when I actually try to do the append to the table, I get a key violation error. How would I fix this and do I need to explain my primary keys and relationships before I can get help?

 

[kramerica]

just a hunch.

When you designed your table you may have fields set with the property "Allow Zero Length" = "NO"

If this is true, then when you run your append query if you has some null values for those fields the query would fail.

Kramerica

 

[jprochelle]

The two fields being appended to are primary keys and number fields. Thus, there is no "allow zero length" field. Do you have any other ideas?