differnce between Execute and recordset

[Bluemonkey]

what is the differnce between the "Execute method" and the "Recordset Object"?? and what are the advantages and disadvantages?

thanks for the help

[miranda]

using execute takes up less server resources and loads faster.

[BigDaddy]

I believe you'd want to use execute for stuff like inserts, deletes, updates--a one-shot deal, where you don't need to pull info back.

Use a recordset for just that--a recordset of info.

[miranda]

can also use the execute method to get information like so
Set Rs = oConn.Execute "SELECT * FROM widgets WHERE color='red'"

And this uses less server resources and is faster than creating a recordset object

[BigDaddy]

Hmm....maybe I need to read up on it a bit more, but I thought you'd only want to use the recordset object for that.