Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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