Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
karimzdn
Contributor
Contributor

How to connect Qlik Sense serverwith accdb

Hello everyone 🙂

 

I would like to establish a connection between Qlik sense Enterprise and an Access database to display tables, but I can't!

I used to use an ODBC connection on Qlik View, but it doesn't seem to work here!

I tried to create a new OLE DB connexion with  :

- Microsoft Office 12.0 Access Database Engine OLE DB Provider and 

- Microsoft jet 4.0 OLE DB Provider 

but it doesn't work 

 

can someone help me ?

Labels (3)
1 Reply
Ray_Strother
Support
Support

Hello,
Have done the following :
1. Add a System DSN on your machine with a Microsoft Access Driver
2. Select your MS Access file
3. Create an ODBC connection in your Qlik sense
4. Made the account has permission in the MS Access Database

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-connect-QlikSense-with-MS-Access-Database/td-...
Thanks