[AccessD] Identify Validation Rules in Access 2007

Thanks Steve,

I'm trying to figure if there are more tables. All I've been told is there
is Table A and Table B.

I've just requested to see if there are relationships.

Thanks
jack

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Sunday, March 29, 2009 8:38 PM
To: Access Developers discussion and problem solving
Subject: Re: [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