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.

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

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Ro" wrote:

> 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.

Ro wrote:
> 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/micro...11008cd57d4a36

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.

--