Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
alindquist
New Contributor III

Reloading data from a MS Access query

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?

1 Solution

Accepted Solutions
alindquist
New Contributor III

Re: Reloading data from a MS Access query

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!

4 Replies
iktrayanov
Contributor III

Re: Reloading data from a MS Access query

Is the database password protected?

Re: Reloading data from a MS Access query

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
Contributor III

Re: Reloading data from a MS Access query

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

alindquist
New Contributor III

Re: Reloading data from a MS Access query

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!

Community Browser