NEW ADO ERRORS

I am trying to execute this code below:
Connection object has already been established and connected.
DIM adoRS as ADODB.Recordset
Set adoRS = New ADODB.Recordset
Set adoRS = adoConnectToSQL.Execute("Select count(*) from tblTempTableBCP",,adcmdtext)

I was reading a book on ADO and I am suppose to be able to do this. But it does not work. I get error 424 Object Required

assuming adoConnectToSQL is a ADO connection object that you have declared and connected, remove this line: Set adoRS = New ADODB.Recordset and it should work

Tom