-
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