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.
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.
ErrorSource: Microsoft Access Database Engine, ErrorMsg: ODBC--connection to 'Livedb' failed.
Why does a linked table in access fail when I can pull data from the other tables and what is the solution?