I click on 'Set up ODBC data sources (32-bit)'.

I'm testing out Qlik View with Access which means, for the first time, I'm trying to install a 32-bit driver on my home PC.

Provided you have a Windows server available to run those drivers, you can then work with MS Access database files from any Python platform using the mxODBC Connect Client.Does anyone have any experience of adding a driver for accdb files under Windows 10? MxODBC Connect Server is compatible with the MS Access ODBC driver on Windows and allows both reading and writing to MDB/ACCDB Access files. MxODBC Connect supports asynchronous query execution via the popular gevent package, provides secure certificate based authentication, SSL encrypted database connections, comes with full support for stored procedures, multiple result sets, Unicode, a common interface on all platforms and implements many other useful features.

As such it supports all database backend that mxODBC supports, but allows connecting to these from many different Python-supported platforms. The product uses mxODBC on the server side and provides a highly portable Python library for the client side.

MxODBC Connect is a commercial client-server product that allows connecting Python to ODBC compatible databases running on remote servers without requiring an ODBC driver on the client side. License eGenix Commercial License 1.3.0 Platforms Client: all Python platforms Server: Windows, Linux Python versions 2.5 - 2.7 This works reasonably well to extract data from the MS Access files. If you only need to query data from MS Access files, you can also have a look at the very limited ODBC driver that comes with the MDBTools. On Unix platforms, you can use one of the ODBC drivers available from commercial ODBC vendors. On Windows, you can use mxODBC with the ODBC driver that comes with MS Access, or use the ODBC driver that comes with the MDAC 2.8 SP1 database access package, if you don't have MS Access installed on the machine. License Commercial License Platforms Windows, Unix Python versions 2.4 - 2.7 However, on Windows Platform, PyPyODBC also provides a set of methods bringing PyPyODBC's extra support for Access on Windows Platform PyPyODBC is a pure Python script module providing ODBC interfacing functions, it runs on CPython / IronPython / PyPy, Version 2.4 / 2.5 / 2.6 / 2.7, Win / Linux, 32 / 64 bit. License MIT Platforms Windows, Linux Python versions 2.4 - 3.4 It comes with the GUI tools,and very user friendly.Licence Commercial/Proprietary software Platforms Windows Microsoft Access mdb and accdb Database URL

Pyodbc with accdb file