• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 423
  • Last Modified:

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

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
stopher2475
Asked:
stopher2475
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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
 
Jeffrey CoachmanMIS LiasonCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now