Problem with append query

[PaulA]

I am trying to use an append query to append records from one table to another with identical field structures.

I am getting an "Unable to append" warning due to key violations although I know the records are not duplicates.

The only thing I can think of must be about the autonumber primary key. Both tables have this. I have tried not both appending the primary key and not appending the primary key from the source table and still get the unable to append.

Other than that, it's a simple append and can't figure out why the target table isn't accepting the records.

Any Ideas?

Thanks.

 

[KKilfoil]

1) Do you have any unique indices other than the primary key?

2) You could create a query from your source table, containing all fields except the primary key, and then append THAT into the target table. You are going to get new numbers for the PK for these records, so they better not be used in any relationships, etc.

 

[KKilfoil]

BTW, as a matter of respecting normalization rules, why do you have more than one table with the identical table structures?

 

[PaulA]

The source table is a temp table where records are appended, modified through an update query, and appended back o the original table as new records. (don't ask me--it's a request from the users).