I have an Access app linked 60% to SQL and 40% to MS Access BE.
Now I have some queries that join tables from both sources, and I am wondering which way would be better for performance.
A- having access front end do the join and filters
B- Establish a linked server connection from SQL to the Access BE, and have the SQL server perform the task.
In case option 'B' is the better option, I would need some guidance how to perform that link properly.
FYI- the SQL database is in one server and the Access BE is in another server, all in one network.