topic Connect Qlikview with Ms Access database (version 2003) in QlikView https://community.qlik.com/t5/QlikView/Connect-Qlikview-with-Ms-Access-database-version-2003/m-p/185788#M50147 <HTML><HEAD></HEAD><BODY><P>Dear ALL,</P><P>Good day. I'm just entry level in Qlikview.</P><P>I have a trouble that i'm not able to connect my Qlikview with the Ms. Access database (2003). My MDB file consist of password. I'm using OLE DB with Ms. Jet 4.0 OLE DB.</P><P>I had input the password into the to establish the connection to the MDB but the error msg of "unable to connect data source" or "Test connection fail because of an error in Initialize provider.</P><P>But everything is all right if i remove the password from my MDB.</P><P>Any idea i can overcome this?</P></BODY></HTML> Thu, 18 Mar 2010 16:29:36 GMT 2010-03-18T16:29:36Z Connect Qlikview with Ms Access database (version 2003) https://community.qlik.com/t5/QlikView/Connect-Qlikview-with-Ms-Access-database-version-2003/m-p/185788#M50147 <HTML><HEAD></HEAD><BODY><P>Dear ALL,</P><P>Good day. I'm just entry level in Qlikview.</P><P>I have a trouble that i'm not able to connect my Qlikview with the Ms. Access database (2003). My MDB file consist of password. I'm using OLE DB with Ms. Jet 4.0 OLE DB.</P><P>I had input the password into the to establish the connection to the MDB but the error msg of "unable to connect data source" or "Test connection fail because of an error in Initialize provider.</P><P>But everything is all right if i remove the password from my MDB.</P><P>Any idea i can overcome this?</P></BODY></HTML> Thu, 18 Mar 2010 16:29:36 GMT https://community.qlik.com/t5/QlikView/Connect-Qlikview-with-Ms-Access-database-version-2003/m-p/185788#M50147 2010-03-18T16:29:36Z Connect Qlikview with Ms Access database (version 2003) https://community.qlik.com/t5/QlikView/Connect-Qlikview-with-Ms-Access-database-version-2003/m-p/185789#M50148 <HTML><HEAD></HEAD><BODY><P>Be sure you have the connection opened at first (including passwords) before selecting the data.</P><P></P><P>Since you use Access I suggest you make an ODBC connection and after this select the things you want.</P><P></P><P>good luck</P><P></P><P>Anita</P></BODY></HTML> Thu, 18 Mar 2010 17:54:04 GMT https://community.qlik.com/t5/QlikView/Connect-Qlikview-with-Ms-Access-database-version-2003/m-p/185789#M50148 Anonymous 2010-03-18T17:54:04Z