l am using VB6 and Access 97 and there seem to be a problem with RDO. l get an
error msg Run-time error '429'; ActiveX component can't create object
There is no problem if l am using ADODB or DAO. l have installed the latest 2.7
libraries but to no avail.
Below is the code l'm using in a module which opens the database
Global Env As rdoEnvironment
Global dbConn As rdoConnection
Global RecSetProd As rdoResultset
Global dB As String
Global path As String
Public Sub OpenDb()
Set Env = rdoEnvironments(0)
path = App.path
dB = "Provider=Microsoft.Jet.OLEDB.3.51;"
dB = dB & "Data Source=\myServer\dbCust.mdb"
Set dbConn = Env.OpenConnection(dB, , True, "")
The error is on the first line of the OpenDb sub
Also any idea where l can download the latest VB6 service pack.
Thanks for your time