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.
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.