Solved

Is there any point to defining Access relationships if you are not enforcing referential integrity?

Posted on 2013-02-06
3
376 Views
Last Modified: 2013-02-06
I'm building an Access database an I hadn't bothered setting up relationships for most of the tables. I'm mostly combining reports from different sources and I can't count on having mappings for all the business units, plants, etc. I'm dropping things that aren't in these look-up tables into "Unknown" buckets. I have created indexes on the fields that are being joined, sorted, etc to speed up performance.
The Access analyze performance tool is suggesting I create the relationships but if I'm not using referential integrity is there any point to doing this. Sure it looks nice in the window and the tables are automatically connected when you drag them into the query builder but are there any other benefits.
0
Comment
Question by:stopher2475
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 38861571
If you are mainly running reports off of these tables, the RI is not really coming into play per se.  RI comes into play when entering data in tables, either directly or via a UI.

So, based on what you are saying, I would say ... No.  

mx
0
 
LVL 57
ID: 38861639
<<Sure it looks nice in the window and the tables are automatically connected when you drag them into the query builder but are there any other benefits.>>

 Second what MX said; no.

Jim.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38861774
Sometimes the relationships make it easier to see what is happening.

For example, seeing a One to Many relationship between tblVGTDER and tblM5TGD...
...tells you that each "VGTDER", ..can have many "M5TGD's"
;-)

I just get nervous when I see a sample db with 10 tables and *no* relationships...
;-)

But I agree with MX, if you will never need the relationships...
...and the system is working just fine without them, ...then don't bother creating them
Doing so might only frustrate you with meaningless (in your case) errors.

Jeff
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now