Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

automatic periodic connection and data download for sharepoint and MS access

The DataBase is an accdb file located on Sharepoint site where client has their data. Accessed through a browser, Windows prompts for a password and after it is provided access is given for opening or saving the file on my machine, so I have no problem connecting manually each time.

I want to connect automatically from QlikView to update the data every several minutes, but when I attempt to do so (OLE DB connect to the path/filename) and test the connection the following message appears:

"Test connection failed because of an error in initializing provider. Not a valid file name."

Could you help me/ give me more info on this point?

I have MS Office 12.0 Access database engine OLEDB provider.

Thank you!

Community Browser