Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
BrunPierre
Master
Master

Loading from Access(.mdb) in a mapdrive fails in the QMC

Hi everyone,

Each time I schedule a reload on the QMC it fails. The .mdb file type sits on another box but mapped on the QV server which I'm able to connect through OLE DB. Also I have assigned all rights to the service account but for some unknown reasons it does run in the QMC but does manually,

Please help! thanks.

1 Solution

Accepted Solutions
Colin-Albert

You need to reference the mdb file using a UNC path such as \\servername\folder\database.mdb instead of a mapped drive. Services cannot access the mapped drive letters.

Your server reload  is run by the QlikView Distribution Service which cannot see the mapped drive letter.

View solution in original post

2 Replies
Colin-Albert

You need to reference the mdb file using a UNC path such as \\servername\folder\database.mdb instead of a mapped drive. Services cannot access the mapped drive letters.

Your server reload  is run by the QlikView Distribution Service which cannot see the mapped drive letter.

BrunPierre
Master
Master
Author

I figured out the solution by using the UNC path.