appending records to another database

[skferranti]

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

[CJ_London]

If you look at the error message, it is telling you one record has a key violation which could be due a duplicate pk

[Micron]

Why do this? Maybe link to this table from the other db? If you try to manage 2 tables containing the same info, not only is it more work than is necessary, it's sure to become out of sync.

[skferranti]

If you look at the error message, it is telling you one record has a key violation which could be due a duplicate pk

Thanks CJ, in looking at the 3 records, they are all different in every field. what is a PK

[skferranti]

CJ, i went in and tried this same thing with just one record and got the same message

[Welshgasman]

Thanks CJ, in looking at the 3 records, they are all different in every field. what is a PK

PK Primary Key
FK Foreign Key

[CJ_London]

they are all different in every field

perhaps in your destination table one of the fields is indexed - no duplicates. Or you have a multi field index on two or more of the fields set as indexed - no duplicates. In either case, if that already exists in your table you will get that error.