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!