Runtime error 429

[jmentor]

I get the error 429. ActiveX component can't create object,. Here is the code that generates the error



Private Sub Command0_Click()
' RDO objects
Dim rdoConn As RDO.rdoConnection
Dim rdoEnv As RDO.rdoEnvironment
Dim rdoEnvs As RDO.rdoEnvironments
Dim rdoRS As RDO.rdoResultset
Dim rdoRSUpdate As RDO.rdoResultset
Dim strSQL As String
' Set Environment
Set rdoEnvs = rdoEngine.rdoEnvironments
Set rdoEnv = rdoEnvs(0)
MsgBox ("OK")
End Sub



I have set a reference to MS Remote Data Object (RDO)

Any help greatly appreciated

[XLGibbs]

I am not familiar with RDO, but you likely have to Set rdoENVS and rdoENV as NEW to create a new instance of the object.