Hi, I am wondering if anyone knows whether or not Access can utilize the CPU/RAM resources of a SQL Server database when querying data in that database through linked tables? Or is the Access query always done 'locally' using the resources of the machine actually running Access?
My department was recently given access to a SQL Server database using Access as the 'client', and our performance of querying the database has been pretty bad.
Thanks.