Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
alexpanjhc
Valued Contributor

MS Access connection from qlikview

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!

Tags (3)
2 Replies
cesaraccardi
Valued Contributor

Re: MS Access connection from qlikview

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.

mov
Esteemed Contributor III

Re: MS Access connection from qlikview

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.