Validation Rule Error

[Guest]

I have created a query appending one table to another. When I run the query
I get the following error message:

Microsoft Access cant append all the records in the append query.
Microsoft Access set (0) fields to null due to type conversion failure and
didn't add (0) records to the table due to key violations, (0) records to
lock violations, and 5598 records due to validation rule violations.
Do you want to run the action query anyway?
To ignore errors and run query click yes.
For an explanation of the causes of the violations click help.

I reviewed the help file without success.

What must I do to correct validation rule error and append one table to
another?

 

[MGFoster]

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

A validation rule is a CHECK constraint on a column or the table. The
CHECK makes sure the values entered into a column meet a defined
criteria. To allow one table's data (table A) to be inserted into
another table (table B) you'd have to validate (change to fit) all the
data in table B before appending to table A. Or, remove the validation,
CHECK constraint, from all the columns in table A.

If it were me, I'd correct the data in table B before inserting into
table A.

See the Access Help articles on "ValidationRule Property," or open a
table in design view & click on a Text column and place the cursor on
the Validation Rule property. Then hit the F1 key - the Help article
should open.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQksbOoechKqOuFEgEQKR9QCglW5otPBHpLlCM0U2e7gKghPiiqkAn2e3
ugqk/tZkg/ffWxyZNcn749WW
=PUmF
-----END PGP SIGNATURE-----