Best way to open a recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Which is more efficient:
Dim a sql_string, queryDef and rec_Set and use VBA code to populate a
recordset

or

use a stored proc and:

set recset = currentdb.openRecordset("the query's name")

to do it?


How would I use the VBA code to pass parameters to these queries?
 
use a stored proc and:
Click to expand...

If you are using SQL server (or any other real client-server dbms) then
moving the processing to the server will always be more efficient: in
network traffic, in workstation activity, and in server workload.

Tim F
 
Back
Top