Reloading data from a MS Access query

[Anonymous]

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?

[iktrayanov]

Is the database password protected?

[Colin-Albert]

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?

[iktrayanov]

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

[Anonymous · Accepted solution]

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!