Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to connect to a MS Access DB from QlikSense without success. I am getting error when I test the connection. Any clue for this?
Thank you!
Thanks guys for your answer, it is already solved I was using a DB with extension .accdb. I needed to install which apparently does not work with all possible connector we have available, so I just selected 'Microsoft Officer 12.0 Access Database Engine OLE DB Provider', it is working now!
Cheers,
Andres
How are you doing it?
Did you create an ODBC connector and corresponding Qlik connector?
VK
Hi Andres
there seems to be a bug in some versions of Qlik Sense that makes it look as if a connection has failed to an Access database when you 'Test' the connection - but in fact the connection has worked fine. I suggest that you ignore the test message, and try to actually use the connection to extract some data - it may work fine.
Hope that helps.
Please mark this as helpful / correct if your question has been answered to your satisfaction
Brian
Thanks guys for your answer, it is already solved I was using a DB with extension .accdb. I needed to install which apparently does not work with all possible connector we have available, so I just selected 'Microsoft Officer 12.0 Access Database Engine OLE DB Provider', it is working now!
Cheers,
Andres
What did you put as path, i tried the same thing and it gives me an error.
Hey guys, I worked it with a Qlik Consultant and he told me to install this file from Microsoft, which include the 'Microsoft Officer 12.0 Access Database Engine OLE DB Provider' connector!
https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255