Qlik Sense Desktop and password protected MS Access 2016 DB

chrihain — Thu, 23 Dec 2021 14:52:48 GMT

Hi all,

we are using Qlik Sense Desktop, Windos 10 and MS Access DB 2016.

Now I try to connect Qlik via OLE DB connection to a password protected MS Access DB.

It works fine with an Access DB without any Password. But if the DB is protected by a password the connection fails. Message : Connections Error: Could not find installable ISAM

The Connection String is the following:

OLEDB CONNECT32 TO [Provider=Microsoft.ACE.OLEDB.16.0; Data Source=C:\Users\dxxxxx\yyyy\yyyy_2017.accdb; Jet OLEDB32: Database password = xxxx;]

Does anyone can give me a hint ?

thanks all

Christiane

topic Qlik Sense Desktop and password protected MS Access 2016 DB in Connectivity & Data Prep

Qlik Sense Desktop and password protected MS Access 2016 DB