OLE DB (Work group info file is missing ) and ODBC (Not a valid password)

[iftikhar_aup]

HI

I want to conncect MS access 2007  database (.mdb ) format to Qlikview.

OLEDB

Step  1 :  Install AccessDatabaseEngine and AccessRuntime_x64_en-us

Step 2  :  Now open Script editor in Qlikview

Step 3 :  From Database  i select   "OLEDB"   tick mark    "Force 32 Bit" and click "Connect"

Step 4 : Now select "Microsoft jet 4.0 OLE DB Provider"   and move to Connection tab.

Step  5 :   Now i enter database name password

                    (1)  Path of database

               (2) User name and password      

and click "Test Connection "  and get the following error

"Test connection failed becaues of an error in initializing  provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user".

ODBC

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

[stabben23]

Hi,

Try this Connector, works for my .mdb files

[iftikhar_aup]

Thanks for reply Mr. Staffan Johansson

i am using the connector which you are specifying

Step 4 : Now select "Microsoft jet 4.0 OLE DB Provider"   and move to Connection tab.

[stabben23]

Ok, I'll missed that, sorry, Can you open the .mdb file in Your MS Access? Use a copy of Your original sourcefile.

[iftikhar_aup]

Yes i can open it

it is password protected

When i enter the password i can see all the tables and quires

[stabben23]

Ok, and that password wont gives you premission to Connect to the .mdb file in Qlikview?

[iftikhar_aup]

ODBC

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

[stabben23]

So you can Select tables With the OBDC connect, but when you try to reload script it fails?

[iftikhar_aup]

yes

[stabben23]

Can you show the script?