Error 'Error evaluating CHECK constraint' in the validation rule.

G

Guest

I am working on Access and I am having problems with my table... I have never
seen the error message before, and I have try different ways to fix the
error, but I still get the same message.

Error 'Error evaluating CHECK constraint.' in the validation rule.

I really apreciate your help. Thanks for all your time in advance.
 
G

Guest

Hi

Without any details of the relationships you have between you tables it
isn't possible to even have a guess at what is causing this error message.

Have a look at this link and if you can't find the answer you're looking for
you could re-post and include some information about the tables and how they
are linked

http://support.microsoft.com/kb/275561/en-us
 
J

Jamie Collins

Ro said:
I am working on Access and I am having problems with my table... I have never
seen the error message before, and I have try different ways to fix the
error, but I still get the same message.

Error 'Error evaluating CHECK constraint.' in the validation rule.

I really apreciate your help. Thanks for all your time in advance.

I've seen that message where the columns' default values exceed the row
limit:

http://groups.google.com/group/micr..._frm/thread/2e6ee72fd3ce3967/c711008cd57d4a36

My assumption is that an engine-level CHECK constraint is automatically
created to test the row limit and the message is seen when the defaults
are applied and the CHECK bites.

I'm very interest to know what is causing the message to show for you.
Please post details of your table.

TIA,
Jamie.

--
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top