While you can use the method above to reference the recordset, you're missing out on one of the huge benefits of working with SQL as a backend.

I'd recommend you start evaluating which of these procedures would be better off written as a stored procedure. Depending on what you're doing with the recordset, you can get a dramatic improvement on performance letting SQL handle your data at the server end.