Run-time error with ADODB

[Guest]

I get the following run-time error when running the following code:

Dim ALP as ADODB.connection
Dim strConnection as string

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;"& _
"Data Source=" & CurrenProject.Path &"\ALP_Score.mdb;"

set ALP = new.ADODB.connection
ALP.Open strConnection (Debug stops here, and run-time error
'-2147467259(80004005)':Could not find installable ISAM)

What have I done wrong to get this error?

Thanks in advance for your advice.

 

[Guest]

Try removing the '.' from between New and ADODB in
set ALP = new.ADODB.connection

And note the spaces on your & _ (Though that could be a function of the post
format)
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & CurrenProject.Path &"\ALP_Score.mdb;"

Anyone else?