Sql server relations in FE

[deletedT]

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.

 

[theDBguy]

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]

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

 

[theDBguy]

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]

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.