Adding linked servers is another step in creating a more complicated scenario
You would have to switch all your queries to pass-through queries and that would make them not updateable. Even doing that, SQL Server has the same problem that Access has. But in this case, it is SQL server that will be dragging the Access data to a temp table on the server prior to the join.This is exactly my point of question here, if the report in question is read only, and I would be using pass-through queries, why is it not worth to have the SQL server do the joining & filtering job instead of the local Access engine? (and we do have a quite powerful server in place with plenty of memory & other resources..)
select * from ... inner join ..on SQLtable.ID = LinkedServertable.ID
Is that not correct?
However, in my experience, linked servers are not very fast, while queries often can be modified for better performance.
/gustav