Hi,

I tried to connect to a password protected  access 2002 db on winxp with the following:

Set mCN = New Connection
    
    With mCN
    'connection to local db
    .ConnectionString= "Provider=Microsoft.JET.OLEDB.4.0;
     password=admin;Data Source = " & strPath
    .CursorLocation = adUseClient
    .Open
    End With

When I run this project i get the following message
"could not find installable ISAM"

How can i resolve this?

PS SP6  for VB6 is installed

(F. Balena - "VB6 Tips and Tricks" - Microsoft Press)
"Q. How to solve the Installable ISAM error?
A. The only way is to move from Jet 3.5 to Jet 4.0.."

I read you already declared the Jet 4.0 engine, and in fact I sometimes experienced it even with Jet 4.0. My suggestion is an attempt: try to connect to your db using an ADODC control, and its Connection String Generator (accessible by right-clicking on the control and choosing Properties). If it works, try to copy and paste the generated ConnectionString to your project.

Oh, another important thing: if your db is protected by a general password (I mean, like by the Tools|Protection MSAccess' menu) the password parameter is not correct. You have to declare it into the connection string like the following:

.ConnectionString= "Provider=Microsoft.JET.OLEDB.4.0;Data Source = " & strPath _     & ";Jet OLEDB: Database Password=" & mypass

Have a look on the following thread: http://www.andreavb.com/forum/viewtopic_3628.html
Just, I never heard that it could affect the Installable ISAM error.

I sometimes got rid of this error simply creating a copy of the db. Anyway, I've not yet understood what this error depends on.

Hope it could be any helpful.

____________________________
Real Programmer can count up to 1024 on his fingers

Thx

I tried a lot of things and nothing helped except, your last line; make a copy....  and now it works fine.