I have 2 databases that are the exact same and would like to append records from one to the other. I created a query to append all the fields and set the criteria to chose the records I want and saved it as an action query. when i tested the query it returned the records i want but when i run it as action i get the error message:
Microsoft Office Access can't append all the records in the append query.
Microsoft Office Access set 0 field(s) to Null due to a type conversion failure, and it didn't add 1 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.
Do you want to run the action query anyway?
To ignore the error(s) and run the query, click Yes.
For an explanation of the causes of the violations, click Help.
I don't know what to do. the 2 tables are exactly the same. My reason is that i want to keep the Master Database on the system at work and be able to add the new record i created while traveling