Database "A" is populated every morning out of another system.
In my database, I have linked to Database A.
Database B contains 15 fields, 8 of which are on Database A.
I would like to have Database B populated by Database A.
I have designed an Append Query to append the field "fac_nbr" in Database A to "Duns" in Database B (both of which are the primary key fields), as well as the remaining 7 fields (address, city, state, zip, etc.).
Each of these fields is defined as "Text" Data Type, with default values in all of the Field Properties.
When I go to run the Append Query, I get the first window that says:
"You are about to append 1017 row(s). ...." That's good. I click "YES".
Then I get the error that says:
"Microsoft Access can't append all the records in the append query.
Microsoft Access set 0 field(s) to Null due to a type conversion failure, and it didn't add 0 record(s) to the table due to key violations, 0 record(s) due to lock violations, and 1017 record(s) due to validation rule violations.
Do you want to run the action query anyway?
To ignore the error(s) and run the query, click Yes."
When I click Yes nothing happens.
My question is, if I'm appending one record to anothr that is the same data typ, how am I getting this error?
This is very frustrating. Any help you could provide would be greatly appreciated! Thank you.
In my database, I have linked to Database A.
Database B contains 15 fields, 8 of which are on Database A.
I would like to have Database B populated by Database A.
I have designed an Append Query to append the field "fac_nbr" in Database A to "Duns" in Database B (both of which are the primary key fields), as well as the remaining 7 fields (address, city, state, zip, etc.).
Each of these fields is defined as "Text" Data Type, with default values in all of the Field Properties.
When I go to run the Append Query, I get the first window that says:
"You are about to append 1017 row(s). ...." That's good. I click "YES".
Then I get the error that says:
"Microsoft Access can't append all the records in the append query.
Microsoft Access set 0 field(s) to Null due to a type conversion failure, and it didn't add 0 record(s) to the table due to key violations, 0 record(s) due to lock violations, and 1017 record(s) due to validation rule violations.
Do you want to run the action query anyway?
To ignore the error(s) and run the query, click Yes."
When I click Yes nothing happens.
My question is, if I'm appending one record to anothr that is the same data typ, how am I getting this error?
This is very frustrating. Any help you could provide would be greatly appreciated! Thank you.
Last edited:
