Error validating constraint.

Microsoft Office Access 2003

Error validating constraint.

The text of the Constraint Expression property does not conform to the constraint syntax recognized by Microsoft SQL Server. Some common reasons why a constraint expression can violate the required syntax are:

  • The expression does not resolve to a value of TRUE or FALSE.
  • The expression misspells a column name, or refers to a column in another table.
  • The expression misspells the name of a function or database constant.

For a complete description of the syntax for constraint expressions in SQL Server 2000, see the SQL Server documentation.