Qlikview and MS Access connectivity Problem(Not a valid password)

iftikhar_aup — Wed, 25 Nov 2020 16:16:04 GMT

I am new to qlikview and want to access data from MS Accss database (.mdb) format.

i follow the following Steps

Step 1 : Install AccessDatabaseEngine and AccessRuntime_x64_en-us

Step 2: Create odbc conncection to my database from script editor

Connection String

ODBC CONNECT TO [MQTU;DBQ=Path\Database.mdb] (XUserId is JCTafQRMNLacWNC, XPassword is aRSBXRdNSLZEDSVOPbFB);

Step 3 : Now i load all the required tables from my database

Step 4: Now Click Reload button to load data form database and it give me an error

SQL##f - SqlState: 42000, ErrorCode: 4294965391, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password.

if my password is wrong then how it load my tables

topic Qlikview and MS Access connectivity Problem(Not a valid password) in QlikView