[AccessD] Cannot Enforce Referential Integrity

Joseph O'Connell joconnell at indy.rr.com
Mon Mar 1 08:19:44 CST 2004


Tina,

Are the tables in the same database?  Referential Integrity cannot be
enforced between databases.  If the parent table is in a BE and the child
table is in the FE then the child table must be moved to the same BE to
allow referential integrity.

Joe O'Connell

-----Original Message-----
From: Tina Norris Fields <tinanfields at torchlake.com>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Date: Sunday, February 29, 2004 3:26 PM
Subject: Re: [AccessD] Cannot Enforce Referential Integrity


|Thanks John and Stuart.  She indicated that the joined fields were PK in
|parent table and FK in child table - but, I will double check.  Thanks
|for the thoughts.
|Tina
|
|John W. Colby wrote:
|
|>Actually if the field in the parent is not designated the PK and / or no
|>index on the child FK.
|>
|>John W. Colby
|>www.ColbyConsulting.com
|>
|>-----Original Message-----
|>From: accessd-bounces at databaseadvisors.com
|>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
|>McLachlan
|>Sent: Saturday, February 28, 2004 6:14 PM
|>To: Access Developers discussion and problemsolving
|>Subject: Re: [AccessD] Cannot Enforce Referential Integrity
|>
|>
|>On 28 Feb 2004 at 15:28, Tina Norris Fields wrote:
|>
|>
|>
|>>A student of mine is trying to remodel a database for her employer.  I
|>>think the database was converted from A97 to AXP (A2K format).  She was
|>>reviewing the relationships and wanted to enforce referential integrity
|>>on one or more relationships.  She reports that the checkbox for
|>>enforcing referential integrity was dimmed and unavailable.  I don't
|>>know much more about this particular database.  Any ideas as to why the
|>>enforce referential integrity choice would be made unavailable?
|>>Thanks,
|>>Tina
|>>
|>>
|>>
|>Usually this happens if there is no unique index on the joined fields
|>in the parent table.
|>
|>
|>--
|>Lexacorp Ltd
|>http://www.lexacorp.com.pg
|>Information Technology Consultancy, Software Development,System
|>Support.
|>
|>
|>
|>--
|>_______________________________________________
|>AccessD mailing list
|>AccessD at databaseadvisors.com
|>http://databaseadvisors.com/mailman/listinfo/accessd
|>Website: http://www.databaseadvisors.com
|>
|>
|>
|>
|>
|
|--
|_______________________________________________
|AccessD mailing list
|AccessD at databaseadvisors.com
|http://databaseadvisors.com/mailman/listinfo/accessd
|Website: http://www.databaseadvisors.com





More information about the AccessD mailing list