Solved

Referential integrity enforcement via linked table

Posted on 2004-04-02
3
491 Views
Last Modified: 2008-03-06
I am placing a relationship between "tblpaymentsreceived" and another table linked from another Access database that includes a joining reference field.

I reconciled both tables to ensure that data in the joining field was reflected in both tables and linked them.

A "One-to-Many" relationship was highlighted in the dialog box but I cannot check the "Enforce Referential Integrity" box.  I have tried inputting an incorrect reference number in "tblpaymentsreceived" and no error message appeared.

Can I not enforce this referential integrity rule because of the linked table?  If so, how can I discipline input (can I place a combo box in the "tblpaymentsreceived" field that only reflects reference numbers from the linked table)?

0
Comment
Question by:MidlandR
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 10740072
Hello MidlandR,

Referential integrity must be enforced in the database where the tables are held (that is - the backend database)



Pete
0
 
LVL 44

Accepted Solution

by:
Arthur_Wood earned 400 total points
ID: 10740091
no, you cannot apply REFERENTIAL integrity rules on LINKED tables.  The rules MUST be established on the Actual Physical tables, themselves.


As for using a Combobox based on the Linked table, to enforce the relationship in code, that is the proper solution fopr this problem.

AW
0
 
LVL 54

Expert Comment

by:nico5038
ID: 10740156
As stated above, this isn't possible.

You basically have two options:
1) Move "tblpaymentsreceived" to the other database
2) "Force" the referential integrety from your application, however when the user(s) have access to the tables, this can fail :-)

Nic;o)
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question