Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
BrunPierre
Partner - Master II
Partner - Master II

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
Partner - Champion
Partner - Champion

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
Partner - Champion
Partner - Champion

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
Partner - Master II
Partner - Master II
Author

I figured out the solution by using the UNC path.