Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Not applicable

Reload fails - MS Access Drivers work directly but not when scheduled

Hi All

I have a document that reloads manually on the server logged in as the service user but doesn't reload with the scheduler?

I've narrowed the problem down to the MSACCESS loads, I've tries both OLEDB and ODBC; they both reload fine manually in developer but fail when scheduled on the server?

Can anyone help?

Thanks

Dominic

1 Solution

Accepted Solutions
Not applicable

Reload fails - MS Access Drivers work directly but not when scheduled

I found that it would reload ok if it was reloading tables and only failed when trying to reload queries?

So to get it work I imported the tables that made up my queries and did all of the joining within Qlikview - this fixed my issue.

View solution in original post

1 Reply
Not applicable

Reload fails - MS Access Drivers work directly but not when scheduled

I found that it would reload ok if it was reloading tables and only failed when trying to reload queries?

So to get it work I imported the tables that made up my queries and did all of the joining within Qlikview - this fixed my issue.

View solution in original post