0 Replies Latest reply: Nov 15, 2011 7:36 AM by iisoiiso RSS

    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!