topic MS Access connection from qlikview in QlikView

MS Access connection from qlikview

alexpanjhc — Tue, 17 Jul 2012 13:41:00 GMT

Hello all

I need to connect to an access database to load data from qlikview

, i used OLE DB (force 32 bits). I then select Micorsoft jet 4.0 OLE DB provider,

the database is in the network,(remote). then i tried to run my qvw file and it always give me the pop-up windows in the attached file.

after I hit OK 3 times, it will run and generate data. but i do not want to manually hit OK.

How can i get rid of it?

Thanks!

Re: MS Access connection from qlikview

cesaraccardi — Tue, 17 Jul 2012 17:10:28 GMT

Hi,

There's a variable called ErrorMode tha can be used to hide dialogs during the script execution. To use this you need to set its value to 0 before the connection and then set it to 1 right after (default value).

Regards,

Cesar.

Re: MS Access connection from qlikview

Anonymous — Wed, 18 Jul 2012 00:14:04 GMT

Regardless the error, I recommend to replace Z with the UNC path, assuming Z is the mapped drive. As a rule, QV Server reload fails with mapped drives.