ADO Recordset Issues on Open Method

N

NotTechSauvy??

I am having issues opening the this ADO recordset I get an error:

Microsoft activeX Data object 2.8 library(msado15.dll)


"Automation error
Unspecified error "


I have the following reference set:


Public Function funDetermineRecordValue(arrReports)
On Error GoTo HandleError


Dim strValue As String
Dim strSQL As String
Dim rstTblAdmin As New ADODB.Recordset


strSQL = "SELECT OutPut FROM TblAdmin"
Debug.Print (strSQL)


'<<<<ERROR HERE>>>>
rstTblAdmin.Open strSQL, CurrentProject.Connection,
adOpenKeyset, adLockOptimistic


Set rstTblAdmin = Nothing


HandleError:
Debug.Print (Err.Description)
End Function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top