Discussion Board for collaboration related to QlikView App Development.
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?
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).
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.