OLEDB connection to Access database with password: "Could not find installable ISAM"

Question

Problem: I get the following error when trying to communicate with an MS Access database via MS Excel: "Could not find installable ISAM".

Excel File Extension = .xlsm
Access File Extension = .mdb
MS Office Version = Office 2013
Operating System = Windows 7 Home Premium (64 Bit)

Troubleshooting Attempts Made:

1. Microsoft Support Page: https://support.microsoft.com/en-us/kb/209805
2. StackOverflow Page A: Troubleshooting Could not find installable ISAM error
3. StackOverflow Page B: How to resolve "Could not find installable ISAM." error for OLE DB provider "Microsoft.ACE.OLEDB.12.0"
4. StackOverflow Page C: Could not find installable ISAM when importing Access table to Excel

Here is the VBA code:

    Dim cnn as New ADODB.Connection
    cnn.Provider = "Microsoft.ACE.OLEDB.12.0;"
    cnn.ConnectionString = "Data Source=" & Range("fld") & "\MyDB.mdb:Jet OLEDB: Database Password=" & "Range("pwdDB")
    '≈Do stuff
    cnn.close
    set cnn = nothing

Does anybody know how to solve this?

Answer 1

Thanks Everyone.

I found out what it was: Leading Equals Sign in the Password (For a protected Access Database).

► Issue: The connection string throws the "Installable ISAM" error if the database password starts with an equal sign ("=").
► Solution: Remove the leading equals sign in the password.

The error message really doesn't detail that, or hint that the password is the problem.

I sure hope this helps someone else in the future.