Share via

Invalid SQL syntax

Anonymous
2020-12-14T20:35:46+00:00

I get the error

Invalid SQL syntax - cannot use multiple columns in a column-level CHECK constraint.

Any clues as to what's wrong?

Thanks,

Jazz Engineering

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-12-14T21:32:25+00:00

    This error usually occurs when you try to save a Validation Rule for a field, and the rule refers to other fields. That is not allowed.

    Create the Validation Rule for the table as a whole instead. You can do this in the Property Sheet.

    24 people found this answer helpful.
    0 comments
  2. Anonymous
    2021-01-20T06:13:26+00:00

    Sir,

    Its new learning for me, which I noted.

    Generally since years I have used validation for the Fields only but never used on the whole table

    To learn more to understand , how to apply by examples on all fields of all type,  I searched, could not found any proper material, being each of the row of property sheet press F1, but still no proper website it takes.

    Would be thankful, if you can share any link where I can read more to understand the implementation, so I will apply and it will effective to all the fields (text, numeric, yes/no).

    Regards

    2 people found this answer helpful.
    0 comments