Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can not find installable ISAM
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can not find installable ISAM
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" On Fri, 26 Oct 2007 07:47:02 -0700, JH wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ODBC Excel Driver Login Failed. Could not find installable ISAM | Excel Discussion (Misc queries) | |||
Need help!!Could not find installable ISAM | Excel Programming | |||
"Can't Find Installable ISAM" error | Excel Programming | |||
Could not find installable ISAM | Excel Programming |