A
Akshay Bakhai
I have 2 tables as follows:
TABLE1 structure is:
primary key = autonumber
Field11 = text, required, no duplicates
Field12 = memo
Field13 = text, not required, not indexed
Field14 = date, not required, not indexed.
TABLE2 structure is:
Field21 = autonumber
Field22 = text, required, duplicates allowed
several other fields.
I wanted to write a query to append records from TABLE2 to
TABLE1. Thus, I have written an APPEND QUERY using source
table as TABLE2. I am using as first column FIELD22 to
populate FIELD12; and I am using the system date to
populate FIELD14.
There are some sample records in TABLE1 and TABLE2 with
values as follows
FIELD12 = "Object1"
"Object2"
"Object3"
FIELD22 = "Object2"
"Object1"
"Object2"
"Text4"
When I execute the query, I get the following errors:
Microsoft Access set 0 field(s) to Null due to a type
conversion failure, and it didn't add 3 record(s) to the
table due to key violations, 0 record(s) due to lock
violations, and 0 record(s) due to validation rule
violations.
I was expecting the 3 key violation errors as TABLE1 has
the no duplicates constraint for field12. However, all
the other errors I have no idea why those have surfaced.
And the Microsoft Access help is not of any help. Since
this is a very simple and small and straightforward
looking example I was stumped as to what am I doing wrong.
Can someone help clarify the issues?
Many thanks for all feedback.
TABLE1 structure is:
primary key = autonumber
Field11 = text, required, no duplicates
Field12 = memo
Field13 = text, not required, not indexed
Field14 = date, not required, not indexed.
TABLE2 structure is:
Field21 = autonumber
Field22 = text, required, duplicates allowed
several other fields.
I wanted to write a query to append records from TABLE2 to
TABLE1. Thus, I have written an APPEND QUERY using source
table as TABLE2. I am using as first column FIELD22 to
populate FIELD12; and I am using the system date to
populate FIELD14.
There are some sample records in TABLE1 and TABLE2 with
values as follows
FIELD12 = "Object1"
"Object2"
"Object3"
FIELD22 = "Object2"
"Object1"
"Object2"
"Text4"
When I execute the query, I get the following errors:
Microsoft Access set 0 field(s) to Null due to a type
conversion failure, and it didn't add 3 record(s) to the
table due to key violations, 0 record(s) due to lock
violations, and 0 record(s) due to validation rule
violations.
I was expecting the 3 key violation errors as TABLE1 has
the no duplicates constraint for field12. However, all
the other errors I have no idea why those have surfaced.
And the Microsoft Access help is not of any help. Since
this is a very simple and small and straightforward
looking example I was stumped as to what am I doing wrong.
Can someone help clarify the issues?
Many thanks for all feedback.