topic Re: Reloading data from a MS Access query in QlikView

Reloading data from a MS Access query

Anonymous — Tue, 21 Jan 2014 22:43:39 GMT

I am loading data from a query in a Microsoft Access database. I am able to connect to the query and reload the data when I run it from the desktop client. However, when I try to schedule a reload task in the Management Console I receive an error saying "The source document was not loaded successfully". I am able to successfully reload through the Management Console when I only try to load an inline table, so I think it has to do with the connection to the Microsoft Access database.

Any thoughts?

Re: Reloading data from a MS Access query

iktrayanov — Tue, 21 Jan 2014 22:52:16 GMT

Is the database password protected?

Re: Reloading data from a MS Access query

Colin-Albert — Tue, 21 Jan 2014 22:53:29 GMT

What is the path to the access database file?

If it is a mapped drive, then the QlikView service may not be able to access the path.

Try using a UNC path to the file in the load script.

Does the QV Service account have permission to open the database?

Re: Reloading data from a MS Access query

iktrayanov — Tue, 21 Jan 2014 22:54:18 GMT

The service account under which the services are running should have access to the MS Access database

Re: Reloading data from a MS Access query

Anonymous — Wed, 22 Jan 2014 01:38:11 GMT

I manually replaced the part of the connection string in the script that had the mapped drive with the UNC path and it worked:

ODBC CONNECT TO [Access Database;DBQ=Q:\Info\DB\Metrics.accdb];

Replaced with:

ODBC CONNECT TO [Access Database;DBQ=\\tfs1\groups\Info\DB\Metrics.accdb];

Thanks!