Comparison of approach SQL=>Access
Posted on 2014-10-23
SQL server 2008 with stored procedures returning data, some with parameters and some without.
MS Access 2007 front end.
What are the efficiency differences, and other considerations, between:
(1) Passthrough query with "EXEC sp"
(2) DAO connection with executed SQL "EXEC sp" & parameters, returning a recordset
(3) ADO connection, making use of the object model and adding parameters, returning a recordset