topic Re: QlikView and MS Access problem in QlikView

QlikView and MS Access problem

Fri, 22 Jul 2011 14:06:06 GMT

Hi,

I am having an issue with QlikView and Access. I have a administration system in ms access which is used to manage models and users, especially email addresses so I can easily create email distribution lists for each model. I have forced the 32bit connection (connect32) and even converted the access database from accdb to mdb. This enabled me to create the oledb connection which works perfectly and when I reload from within the model I have no issues at all.

My problem comes in when I try reload the model through the Managment Console, it keeps failing??? If I take out code connecting to Access it works fine.

QlikView and MS Access problem

danielrozental — Fri, 22 Jul 2011 14:11:08 GMT

Probably the user running QlikView Distribution Service doesn't have access to the access database

QlikView and MS Access problem

Fri, 22 Jul 2011 14:59:48 GMT

The email addresses are being pulled from the access database into a qlikview variable which is then being used in the 'Alert' function on a post reload trigger to populate the mail recipients. The database is stored on the qlikview server Data folder and all administrators have access to the folder and file.

/*OLEDB CONNECT32 TO [Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=\\qlikview-01\qlikview\QVData\Data\QlikViewModelOverview.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False];

tmpDistributionList:

SQL SELECT Email,

Model As QVModel

FROM `QV_Details`

WHERE Model = 'Stock Analysis';

tmpConcat:

LOAD concat(Email & ';') AS EmailList

RESIDENT tmpDistributionList;

Let vEmailList = fieldvalue('EmailList',1);*/

Re: QlikView and MS Access problem

Thu, 28 Jun 2012 13:56:09 GMT

Solved this by upgrading to QlikView 10, apparently an issue with QV 9 and the OLEDB CONNECT 32.