Sql server relations in FE (1 Viewer)

deletedT

Guest
Local time
Today, 01:33
Joined
Feb 2, 2019
Messages
1,218
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:

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:33
Joined
Oct 29, 2018
Messages
21,358
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.
 

deletedT

Guest
Local time
Today, 01:33
Joined
Feb 2, 2019
Messages
1,218
Yes, I meant adding relationship between linked tables.
thanks for your input.
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 18:33
Joined
Oct 29, 2018
Messages
21,358
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)
 

sonic8

AWF VIP
Local time
Today, 02:33
Joined
Oct 27, 2015
Messages
998
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.
 

Users who are viewing this thread

Top Bottom