Check Contraint error message?

[Salad]

Last week, 2 different times, a person closed the form and received a
"Error Evaluating Check Constraint in the validation rule" I have no
idea what the error number is for this error. I have no validation
rules on the table or controls. Does anybody have a clue what would
trigger this error message?

[Tom van Stiphout]

On Tue, 08 Jul 2008 08:33:34 -0700, Salad <oi*@vinegar.comwrote:

I bet this is an Access db with a SQL backend, a little gem you left
out of your description.
Look up Check Constraints in Books Online, the SQL Server help file.

-Tom.

>Last week, 2 different times, a person closed the form and received a
"Error Evaluating Check Constraint in the validation rule" I have no
idea what the error number is for this error. I have no validation
rules on the table or controls. Does anybody have a clue what would
trigger this error message?

[Salad]

Tom van Stiphout wrote:

On Tue, 08 Jul 2008 08:33:34 -0700, Salad <oi*@vinegar.comwrote:

I bet this is an Access db with a SQL backend, a little gem you left
out of your description.
Look up Check Constraints in Books Online, the SQL Server help file.

-Tom.

I wish that were the problem. The front end is A2003. The backend is
still in A97 format because there's a couple still in A97. Shortly
everyone will be A2003. I think that the error occurred with an A2003
machine.

>>Last week, 2 different times, a person closed the form and received a
"Error Evaluating Check Constraint in the validation rule" I have no
idea what the error number is for this error. I have no validation
rules on the table or controls. Does anybody have a clue what would
trigger this error message?

[Tom van Stiphout]

On Tue, 08 Jul 2008 21:01:58 -0700, Salad <oi*@vinegar.comwrote:

Could it be it's not a standard runtime error but a custom one
generated by the app?
-Tom.

>Tom van Stiphout wrote:

>On Tue, 08 Jul 2008 08:33:34 -0700, Salad <oi*@vinegar.comwrote:

I bet this is an Access db with a SQL backend, a little gem you left
out of your description.
Look up Check Constraints in Books Online, the SQL Server help file.

-Tom.

I wish that were the problem. The front end is A2003. The backend is
still in A97 format because there's a couple still in A97. Shortly
everyone will be A2003. I think that the error occurred with an A2003
machine.

>>>Last week, 2 different times, a person closed the form and received a
"Error Evaluating Check Constraint in the validation rule" I have no
idea what the error number is for this error. I have no validation
rules on the table or controls. Does anybody have a clue what would
trigger this error message?

[Salad]

Tom van Stiphout wrote:

On Tue, 08 Jul 2008 21:01:58 -0700, Salad <oi*@vinegar.comwrote:

Could it be it's not a standard runtime error but a custom one
generated by the app?
-Tom.

I really don't know. The person said it was when they exited a form.
Both times it was the same form. The form hasn't been modified in a
while. Since it's happened twice in hundreds/thousands of
opening/closing the form by many people I'd think I'd get the error more
often.

My problem is that I'm off site and am informed long after the error
occurred when it'd be fresh in the mind of the user. I don't know what
routine caused the error so this makes it hard for me to track down.

>

>>Tom van Stiphout wrote:

>>>On Tue, 08 Jul 2008 08:33:34 -0700, Salad <oi*@vinegar.comwrote:

I bet this is an Access db with a SQL backend, a little gem you left
out of your description.
Look up Check Constraints in Books Online, the SQL Server help file.

-Tom.

I wish that were the problem. The front end is A2003. The backend is
still in A97 format because there's a couple still in A97. Shortly
everyone will be A2003. I think that the error occurred with an A2003
machine.

>>>>Last week, 2 different times, a person closed the form and received a
"Error Evaluating Check Constraint in the validation rule" I have no
idea what the error number is for this error. I have no validation
rules on the table or controls. Does anybody have a clue what would
trigger this error message?

[Tom van Stiphout]

On Tue, 08 Jul 2008 21:56:19 -0700, Salad <oi*@vinegar.comwrote:

One intermediate step would be to outfit the application with a better
error handler, at least in that area. One that writes to an error log
file as well.

-Tom.

>Tom van Stiphout wrote:

>On Tue, 08 Jul 2008 21:01:58 -0700, Salad <oi*@vinegar.comwrote:

Could it be it's not a standard runtime error but a custom one
generated by the app?
-Tom.

I really don't know. The person said it was when they exited a form.
Both times it was the same form. The form hasn't been modified in a
while. Since it's happened twice in hundreds/thousands of
opening/closing the form by many people I'd think I'd get the error more
often.

My problem is that I'm off site and am informed long after the error
occurred when it'd be fresh in the mind of the user. I don't know what
routine caused the error so this makes it hard for me to track down.

>>

>>>Tom van Stiphout wrote:

On Tue, 08 Jul 2008 08:33:34 -0700, Salad <oi*@vinegar.comwrote:

I bet this is an Access db with a SQL backend, a little gem you left
out of your description.
Look up Check Constraints in Books Online, the SQL Server help file.

-Tom.

I wish that were the problem. The front end is A2003. The backend is
still in A97 format because there's a couple still in A97. Shortly
everyone will be A2003. I think that the error occurred with an A2003
machine.


>Last week, 2 different times, a person closed the form and received a
>"Error Evaluating Check Constraint in the validation rule" I have no
>idea what the error number is for this error. I have no validation
>rules on the table or controls. Does anybody have a clue what would
>trigger this error message?