Problem with combining tables!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to combine three tables into one Master table. I have been doing
this through appended queries. I can get the first appended query to work
but the next two do not work and I get a message that says "Access can't
append all the records" and something about conversion failure and validation
rule violation. I have check all the the fields to make sure they match but
I still get the error. What can I do? Is there another way to combine the
tables?
 
The error could be due to several things.

Some examples:

a) There is a unique index (primary key, or No Duplicates index) on a field
or fields, and the data you are trying to add would be a duplicate.

b) The field has the Required property set to Yes, but the data has no value
for that field.

c) The field has the Allow Zero Length property set to No (as it should),
but the data contains zero-length-strings instead of nulls.

d) One of the fields is a foreign key to another table, but the data you are
adding has values that are not in the matching table.

e) There is something in the Validation Rule of one of the fields in the
table, and the data you are trying to add does not meet this rule.

f) There is something in the Validation Rule of the table (Properties box,
in table design), and the data you are trying to add does not meet this
rule.

g) The data you are trying to append does not match the field type in the
table. For example, you are trying to append the word "unknown" to a date
field or a number field.
 
Thanks, it was the primary key!! :)

Allen Browne said:
The error could be due to several things.

Some examples:

a) There is a unique index (primary key, or No Duplicates index) on a field
or fields, and the data you are trying to add would be a duplicate.

b) The field has the Required property set to Yes, but the data has no value
for that field.

c) The field has the Allow Zero Length property set to No (as it should),
but the data contains zero-length-strings instead of nulls.

d) One of the fields is a foreign key to another table, but the data you are
adding has values that are not in the matching table.

e) There is something in the Validation Rule of one of the fields in the
table, and the data you are trying to add does not meet this rule.

f) There is something in the Validation Rule of the table (Properties box,
in table design), and the data you are trying to add does not meet this
rule.

g) The data you are trying to append does not match the field type in the
table. For example, you are trying to append the word "unknown" to a date
field or a number field.
Click to expand...
 
Back
Top