Go Back   Access World Forums > Apps and Windows > SQL Server

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-19-2019, 05:42 PM   #1
Tera
Newly Registered User
 
Join Date: Feb 2019
Posts: 300
Thanks: 491
Thanked 22 Times in 21 Posts
Tera is on a distinguished road
Sql server relations in FE

I have a sql server BE with all necessary relationships.
FE is a Microsoft Access database with linked table to sql server.

Will be any change in performance if I add the same relations between tables in FE's linked table too?


Thanks for any kind of advice.


Last edited by Tera; 09-19-2019 at 09:53 PM.
Tera is offline   Reply With Quote
Old 09-19-2019, 06:59 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,914
Thanks: 57
Thanked 1,293 Times in 1,274 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Sql server relations in FE

Hi. If you’re referring to creating relationships among the linked tables, I don’t think it would mean anything to the database. So, you could try it if it will make you feel better, but it’s not really necessary. Table relationships only matters within the same container where the tables are stored.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
Tera (09-19-2019)
Old 09-19-2019, 09:54 PM   #3
Tera
Newly Registered User
 
Join Date: Feb 2019
Posts: 300
Thanks: 491
Thanked 22 Times in 21 Posts
Tera is on a distinguished road
Re: Sql server relations in FE

Yes, I meant adding relationship between linked tables.
thanks for your input.

Tera is offline   Reply With Quote
Old 09-20-2019, 04:12 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,914
Thanks: 57
Thanked 1,293 Times in 1,274 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Sql server relations in FE

Quote:
Originally Posted by Tera View Post
Yes, I meant adding relationship between linked tables.
thanks for your input.
Right, that's not something you need to do. (as far as I know)
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 09-20-2019, 05:48 AM   #5
sonic8
AWF VIP
 
Join Date: Oct 2015
Posts: 269
Thanks: 44
Thanked 76 Times in 73 Posts
sonic8 is on a distinguished road
Re: Sql server relations in FE

Quote:
Originally Posted by Tera View Post
Will be any change in performance if I add the same relations between tables in FE's linked table too?
No. The relationships in the frontent are pretty much irrelevant.
Not sure, if you can create them at all, but it won't do any more than pre-linking tables in query design view.

__________________
New article:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
sonic8 is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Recurring relations RandBlade Theory and practice of database design 4 12-03-2012 10:29 AM
Relations not getting right HV_L Tables 32 02-13-2011 02:42 PM
How to Create Relations spooky30 General 2 11-10-2008 08:14 PM
Forms and relations Andren General 2 03-07-2003 02:07 AM
Many to many relations Kasiat Tables 3 11-12-2002 07:43 AM




All times are GMT -8. The time now is 01:17 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World