Unable to select .mdb Access Database Type in OBDC

[rosenthalj]

I know there are a lot of "connect to microsoft access db" questions, but I can't seem to figure this one out. When using the OBDC tool and following the directions found in both the community and on YouTube videos, I still only have the Amazon Redshift option. I installed the most recent OLEDB driver and still have no luck. Any guidance would be greatly helpful. Thank you.

[rubenmarin · Accepted solution]

Hi, that dialog connects to an already created ODBC connection

Steps for creating ODBC in this thread: https://community.qlik.com/t5/QlikView-App-Development/No-Microsoft-Access-selection-for-OLE-DB-conn...

And about OLEDB in this one: https://community.qlik.com/t5/QlikView-App-Development/OLE-DB-Connection-for-Access-Database/td-p/86...

[Brett_Bleess]

Below is an external link I found that has screenshots on things as well, might be a bit more helpful...

http://www.fekete.com/SAN/WebHelp/FeketeHarmony/Harmony_WebHelp/Content/HTML_Files/Setting_up_Your_D...

Just Google Microsoft Access DSN, and you should get quite a few hits there...

Regards,
Brett