topic failed connection to Linked Table in Access in QlikView https://community.qlik.com/t5/QlikView/failed-connection-to-Linked-Table-in-Access/m-p/1215710#M873079 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>First I must say I have just opened a QVW written by another developer, so I may not have all the access rights to various databases.</P><P></P><P>I have a OLEDB connection to an access database that is working as I can pull data from it. But when the code is inner joined to a linked table inside the access database Qlik will produce an error.</P><P></P><P>ErrorSource: Microsoft Access Database Engine, ErrorMsg: ODBC--connection to 'Livedb' failed.</P><P></P><P>Why does a linked table in access fail when I can pull data from the other tables and what is the solution?</P><P></P><P>Thanks</P><P></P><P>Neil.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT tinkerz1 2020-11-25T16:16:04Z failed connection to Linked Table in Access https://community.qlik.com/t5/QlikView/failed-connection-to-Linked-Table-in-Access/m-p/1215710#M873079 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>First I must say I have just opened a QVW written by another developer, so I may not have all the access rights to various databases.</P><P></P><P>I have a OLEDB connection to an access database that is working as I can pull data from it. But when the code is inner joined to a linked table inside the access database Qlik will produce an error.</P><P></P><P>ErrorSource: Microsoft Access Database Engine, ErrorMsg: ODBC--connection to 'Livedb' failed.</P><P></P><P>Why does a linked table in access fail when I can pull data from the other tables and what is the solution?</P><P></P><P>Thanks</P><P></P><P>Neil.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/failed-connection-to-Linked-Table-in-Access/m-p/1215710#M873079 tinkerz1 2020-11-25T16:16:04Z Re: failed connection to Linked Table in Access https://community.qlik.com/t5/QlikView/failed-connection-to-Linked-Table-in-Access/m-p/1215711#M873080 <HTML><HEAD></HEAD><BODY><P>This is OLEDB driver issue .. Try to download and install the latest driver </P><P><SPAN style="color: #333333; font-family: 'Segoe UI', Arial, sans-serif; font-size: 15px;">also download <BR /></SPAN></P><P><SPAN style="color: #333333; font-family: 'Segoe UI', Arial, sans-serif; font-size: 15px;">Microsoft Access Database Engine Redistributable</SPAN></P></BODY></HTML> Tue, 08 Nov 2016 17:34:53 GMT https://community.qlik.com/t5/QlikView/failed-connection-to-Linked-Table-in-Access/m-p/1215711#M873080 ziadm 2016-11-08T17:34:53Z