Does anyone know how to turn off the use of ODBC Stored Procedures to
prepare statements to run against SQL 7 using MDAC 2.1? This is possible
under using earlier versions of the products but not with this combination.
This is the only way I have found to get MS Access to send the query to the
server instead of trying to resolve the query it self. Without being able
to turn this off, MS Access just crawls or times out especially with queries
with several joins over large tables. Executing the same query directly on
SQL server nets an almost immediate result.
SQL Database Administrator