Is there a CONSTRAINT CHECK in Access SQL?

Seems like it should work but I've tried it and it won't!
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

In the Database window, click Database Diagrams  under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
In your database diagram, right-click the table that will contain the constraint, then select Constraints from the shortcut menu.
Choose New. The Selected constraint box displays the system-assigned name of the new constraint. System-assigned names begin with "CK_" followed by the table name.
In the Constraint expression box, type the SQL expressions for the check constraint. For example, to limit the entries in the state column of the authors table to New York, type: state = 'NY'

Note   Make sure to enclose any non-numeric constraint values in single quotation marks (').

If you want to give the constraint a different name, type the name in the Constraint name box.
Use the check boxes to control when the constraint is enforced:
To test the constraint on existing data before creating the constraint, check Check existing data on creation.
To enforce the constraint whenever a replication operation occurs on this table, check Enforce constraint for replication.
To enforce the constraint whenever a row of this table is inserted or updated, check Enforce constraint for INSERTs and UPDATEs.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bibetaAuthor Commented:
The answer is not for Access 2007.
bibetaAuthor Commented:
It wasn't for access 2007
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.