Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this Connector, works for my .mdb files
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.
Ok, I'll missed that, sorry, Can you open the .mdb file in Your MS Access? Use a copy of Your original sourcefile.
Yes i can open it
it is password protected
When i enter the password i can see all the tables and quires
Ok, and that password wont gives you premission to Connect to the .mdb file in Qlikview?
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
So you can Select tables With the OBDC connect, but when you try to reload script it fails?
yes
Can you show the script?