Provider cannot be found - it may not be properly installed. 1

[jojones]

I have the following code to connect to an Access db, but I am getting "Run time error 3706: Provider cannot be found. It may not be properly installed."

My code is:

mydB = "C:\Financial_Reporting\Data_Sources\Replicable\" & _
"Variables_Data.mdb"

myPwd = "admin"
Set myCnn = New ADODB.Connection
With myCnn
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.2.5;" & _
"Data Source=" & mydB & ";" & _
"Persist Security Info=False;" & _
"Jet OLEDBatabase Password=" & myPwd
myCnn.Open
End With

How do I know which provider to use? Can anyone help me? I am using VB 6 and Access 97.

thanks
Jo

 

[mattKnight]

Jo,

Try "Provider=Microsoft.Jet.OLEDB.3.51"

I think 3.51 is correct version for access 97

hoe it helps

Matt