Article ID: 201888 - View products that this article applies to.
This article was previously published under Q201888
This article has been archived. It is offered "as is" and will no longer be updated.
Advanced: Requires expert coding, interoperability, and multiuser skills.
The new SQL grammar exposed by Microsoft Jet database engine version 4.0 allows users to specify business rules that can span more than one table. These are called check constraints and allow users to exceed a single validation rule per table. In this article, a procedure is provided that demonstrates creating a table with a CHECK constraint. It also tests this constraint by attempting to add two records, one which conforms to the constraint, and one that intentionally violates the constraint.
To demonstrate the example procedure, follow these steps:
Contact us for more help