I get the previously mentioned error on a form with 3 Ado
data control whose properties I set at run-time. Here's the section of code that generates the error:
With adoFunds
.Mode = adModeReadWrite
.ConnectionString = objConnect.ConnectionString
.CommandType = adCmdTable
.RecordSource = "Funds"
.Refresh
End With
With adoCategory
.Mode = adModeReadWrite
.ConnectionString = objConnect.ConnectionString
.CommandType = adCmdTable
.RecordSource = "Category"
.Refresh
End With
With adoNames
.Mode = adModeReadWrite
.ConnectionString = objConnect.ConnectionString
.CommandType = adCmdTable
.RecordSource = "Names"
.Refresh
End With
The error is generated when I try to run the refresh method of adoNames. Any Ideas why this error is generated? I looked up help and it described this as being an automation error 440 which means an attempt to run an objects method generated an error. I'm using vb.6.0 with SP5. Referencing MS ADO 2.5 library. Do I really need to use 3 ADO data controls? Any help and/or suggestions are welcome.
data control whose properties I set at run-time. Here's the section of code that generates the error:
With adoFunds
.Mode = adModeReadWrite
.ConnectionString = objConnect.ConnectionString
.CommandType = adCmdTable
.RecordSource = "Funds"
.Refresh
End With
With adoCategory
.Mode = adModeReadWrite
.ConnectionString = objConnect.ConnectionString
.CommandType = adCmdTable
.RecordSource = "Category"
.Refresh
End With
With adoNames
.Mode = adModeReadWrite
.ConnectionString = objConnect.ConnectionString
.CommandType = adCmdTable
.RecordSource = "Names"
.Refresh
End With
The error is generated when I try to run the refresh method of adoNames. Any Ideas why this error is generated? I looked up help and it described this as being an automation error 440 which means an attempt to run an objects method generated an error. I'm using vb.6.0 with SP5. Referencing MS ADO 2.5 library. Do I really need to use 3 ADO data controls? Any help and/or suggestions are welcome.