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

[#1]

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

[#2 · Accepted solution]

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.