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
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!