Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

failed connection to Linked Table in Access

Hi,

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?

Thanks

Neil.

1 Reply
ziadm
Specialist
Specialist

This is OLEDB driver issue .. Try to download and install the latest driver

also download

Microsoft Access Database Engine Redistributable