topic Re: Cannot see Access Query if it calls a Function in QlikView

Cannot see Access Query if it calls a Function

dhborchardt — Thu, 12 Sep 2013 17:12:36 GMT

I cannot connect to an access query (does not appear in 'Create Select Statement/Database tables') if a function call is made to a module within the query I am attempting to select from. I tried to use anther query on top of that one but still did not appear in the 'Create Select Statement' window. Is this a limitation or am I doing something wrong?

Access 2010

Qlikview 11, 64 bit

Re: Cannot see Access Query if it calls a Function

Gysbert_Wassenaar — Thu, 12 Sep 2013 17:18:00 GMT

As far as I know that's a limitation of the odbc/oledb driver for MS-Access. It allows access to the data, but won't run code.

Re: Cannot see Access Query if it calls a Function

dhborchardt — Thu, 12 Sep 2013 18:09:23 GMT

Thanks. In this case I was able to accomplish it pretty simply in the load statement. What is the workaround if there is no easy button?

Re: Cannot see Access Query if it calls a Function

Gysbert_Wassenaar — Thu, 12 Sep 2013 18:19:07 GMT

Try to rewrite the logic in qlikview script. It's pretty powerful so it might surprise you what you can do. And ask us if you need help.
Use a 'real' database as data source
Create a vbscript function in the module and call it as a function in the script (example here).

Re: Cannot see Access Query if it calls a Function

dhborchardt — Thu, 12 Sep 2013 18:44:34 GMT

Yeaaa,, I was waiting for that. Unfortunately I was not there for that decision. Thanks again.