Validation Rule Error

Discussion in 'Microsoft Access Queries' started by Guest, Mar 30, 2005.

  1. Guest

    Guest 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?
     
    Guest, Mar 30, 2005
    #1
    1. Advertisements

  2. Guest

    MGFoster Guest

    -----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-----


    syoung wrote:
    > 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, Mar 30, 2005
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Matt J

    Validation Rule Violations on Append queries

    Matt J, Sep 26, 2003, in forum: Microsoft Access Queries
    Replies:
    0
    Views:
    225
    Matt J
    Sep 26, 2003
  2. hawk

    Constant validation rule error messages...why?

    hawk, Oct 27, 2003, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    288
    Joan Wild
    Oct 27, 2003
  3. Guest

    validation rule error - append query

    Guest, Jan 30, 2004, in forum: Microsoft Access Queries
    Replies:
    3
    Views:
    1,435
    Guest
    Feb 16, 2004
  4. just a guy

    MS Access update query -Validation rule error

    just a guy, Apr 1, 2004, in forum: Microsoft Access Queries
    Replies:
    3
    Views:
    996
    Allen Browne
    Apr 2, 2004
  5. S Davis
    Replies:
    2
    Views:
    453
    Marshall Barton
    Sep 21, 2007
Loading...

Share This Page