Hi,
I am trying to connect to an Access Database by setting up a DSN ODBC connection referencing the Access driver to connect to accdb files i.e in Designer selecting “Data Sources” > Generic Connection ODBC and choosing DSN. However I am getting the following error:
"Input Data (x): The specified DSN contains an architecture mismatch between the Driver and Application"
Looking at the link on how to resolve that error (https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-quot-Input-Data-x-The-specified-DSN-contains-an/ta-p/634148) it says that I need to install the 64-bit driver version for the database. However, in the first link provide there (“download page”) I cannot find any driver to download for Microsoft Access database. Only on the second link on that article (“Data Source page”) I could find an Access driver for Microsoft Access 2007, 2010, 2013, 2016. After downloading it I keep having the same error message. I was told by Alteryx support that the Data Sources I am trying to use aren't natively supported by Alteryx. Since the connection is still throwing errors with the drivers, they suggested posting this to Dev Space community to see hopefully find a solution?
