[AccessD] Identify Validation Rules in Access 2007

Jack,

When an append query returns a validation rule error, it does not 
necessarily mean that a Validation Rule has been breached. :-)  For example, 
it can mean that Referential Integrity in a Relationship will be violated, 
i.e. the table being appended to is on the "many" side of a one-to-many 
relationship, and there is no matching record in the "one" side table for 
the records you are attempting to append.

Regards
Steve


--------------------------------------------------
From: "Jack and Pat" <drawbridgej at sympatico.ca>
Sent: Monday, March 30, 2009 2:31 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: [AccessD] Identify Validation Rules in Access 2007

>
> I'm trying to help someone remotely with an Access 2007 issue. I don't 
> have
> 2007. He is running an Append query, but is getting Validation rule error.
> All records destined for the Append are rejected.
>
> He is unfamiliar with the original table, and Access generally.
>
> He has 2 tables. A is his master table. B is the table with records to be
> appended to A, if they don't already exist in A.
>
> Field types in both tables match.
>
> Is there a way programmatically, or some other way, to identify what the
> validation rule is/are?
>