But do you really need the results as tables? It is not that the users can take off with them as they would with Excel files unless the contents are exported. A view/query resultset would not have the problems you describe and the results can be exported as well.
Of course, Access across a network is always fun. Better not have a T1 in there...