can not find installable ISAM

J

JH

Hi,
I have an Excel macro with an ADO query accessing an Access database
table, before I set a database password on it, everything works fine.
After I set a database password and added the password to my code.

as follow:
stConn = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" & stDB & ";" & "Properties(Jet OLEDB:Database
Password)='password'"

I am now getting an run time error "Can not find installable ISAM."

Can someone please help?
Thanks!
 
M

Myrna Larson

Is the code you posted taken verbatim from your macro? If so, is the database
password REALLY password ?? If not, you should have the actual password
between the single quotes.

Here's the example from Access ADO Help, which uses a connection object, but
maybe it will help. Note that a user ID is supplied in addition to a password.
Could that be the problem?

Set Cnxn2 = New ADODB.Connection
Cnxn2.Provider = "Microsoft.Jet.OLEDB.4.0"
Cnxn2.Open "C:\Program Files\Microsoft Office\Office\Samples\northwind.mdb", _
"MyUserID", "MyPassword"
 

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