Access 2002 Append Query Problems

[DaughterJulie]

I get this error reading, "Microsoft Access can't append all records in the
append query... 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) to due to
validation rule violations" when I do an append query to remove duplicates
from my primary table. My databases from Crystal weren't working (saved in
Excel, only values), so I tested Access by creating a control database and
running the same append query to remove duplicates from the original table (6
records), and I still got this message. I've checked type conversion on all
my fields, and they seem good. Any ideas on what could be happening?

 

[MGFoster]

I get this error reading, "Microsoft Access can't append all records in the
append query... 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) to due to
validation rule violations" when I do an append query to remove duplicates
from my primary table. My databases from Crystal weren't working (saved in
Excel, only values), so I tested Access by creating a control database and
running the same append query to remove duplicates from the original table (6
records), and I still got this message. I've checked type conversion on all
my fields, and they seem good. Any ideas on what could be happening?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Usually, that error is for records that have the same Primary Key or a
column (Field) that has a Unique constraint (index). Have you run the
"Find Duplicates Query Wizard" on the source data? Just search on the
primary key or unique columns in the duplicates query. Then delete or
change those records. Then try the Append query.

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSkUh24echKqOuFEgEQKz4wCfVRSFpVPk9ISr/RKjV9olPz4RV0MAn2lG
EHM/YDH4kiXJ2YJ7yrDmQ+fP
=E+lL
-----END PGP SIGNATURE-----

 

[KARL DEWEY]

Sounds like you have duplicates.
Create a Totals query putting both tables in the query design view above the
grid.
Click on your primary key field and drag to the other table matching field.
Pull down the primary key field to the Field row and do the same with the
matching field from the other table.
Click on the Totals icon (looks like an 'M' on its side - ∑ ), select Count
as the option for the matching field and Descending as the sort.

Run the query to see how many records in the other table you are trying to
append into a single record - the Key Violations.