Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
dilipkumard13
New Contributor III

how to connect password protected ms access (.accdb) File in Qlik sense

Im unable to connect to MS Access file.

Only we have password.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: how to connect password protected ms access (.accdb) File in Qlik sense

 

Create a ODBC connection at: c:\Windows\Syswow64\odbcad32.exe. If you dont have the drive, download here: https://www.microsoft.com/en-us/download/details.aspx?id=54920

 

In ADVANCED options from ODBC, enter with username and password.

 

odbc.png

Support your colleagues. Remember to "like" the answers that are helpful to you and flag as "solved" the one that helped you solve. Cheers.

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: how to connect password protected ms access (.accdb) File in Qlik sense

 

Create a ODBC connection at: c:\Windows\Syswow64\odbcad32.exe. If you dont have the drive, download here: https://www.microsoft.com/en-us/download/details.aspx?id=54920

 

In ADVANCED options from ODBC, enter with username and password.

 

odbc.png

Support your colleagues. Remember to "like" the answers that are helpful to you and flag as "solved" the one that helped you solve. Cheers.

View solution in original post

Highlighted
dilipkumard13
New Contributor III

Re: how to connect password protected ms access (.accdb) File in Qlik sense

Im not having the username.