Append Query.....

[T Miller]

I have two tables that are the same, no validation rules all field names are
equal. Now when I go to append them I get a type conversion failure, key
violations, lock violations, and validation rule violations????? Why is this
happening? And, if I ignore it only appends 50,313 of 62,952....

What could be causing this to happen?

 

[KARL DEWEY]

That error message includes the number of records that were in error for each
of the reasons. You need to analyze based on the stated reasons.

You did not say if you did/did not have a primary key field. This could
result in key violations.

 

[T Miller]

KARL,

There is not a primary key assigned in either table and there are no
validation rules applied to any of the fields. I am at a complete loss with
this one.....

 

[KARL DEWEY]

So what type of error did the message have record counts?

 

[John Spencer]

Any UNIQUE Indexes?
Any relationships to other tables with integrity enforced?

 

[Cynthia]

Karl,
I just got that error recently when I had a null value in a field.

 

[KARL DEWEY]

Check the field properties to see if nulls are allowed or zero lenght strings
are allowed.