Run-time error with ADODB

K

kfng

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.
 
P

PJFry

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top