Run-Time error 3802

[MikeC14081972]

I'm using Access 2000

I'm trying to add data to a table and I'm getting the following error message which I have never come up against before and it's got me stumped.

Run-time error '3802'
'Error evaluating CHECK constraint'

This happens if I try to add data via a Query, Executing a SQL Insert Statement or even just typing direct to the table.

Anyone got any ideas as there is nothing useful out there on Google.

Thanks

Mike.

 

[genomon]

Open the table in design view. If there is a validation rule declared, delete it & see what happens.

Ever notice how fast Windows runs? Me neither.

 

[MikeC14081972]

Thanks

Did try that, theres no validation rules just default values, that's whats got me confused.

 

[genomon]

Have you tried recreating the table from scratch, and pasting in the old data?

Ever notice how fast Windows runs? Me neither.