MS Access library for python
Question: Is there a library for using MS Access database in python? The win32 module is
not as easy as the MySQL library. Is there a simpler way to use MS Access with
Python?


Answer: Depending on what you want to do,
[pyodbc](https://github.com/mkleehammer/pyodbc) might be what you are looking
for.

    
    
    import pyodbc
    db_file = r'''C:\x.mdb'''
    user = 'admin'
    password = ''
    
    odbc_conn_str = 'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=%s;UID=%s;PWD=%s' %\
                    (db_file, user, password)
    # Or, for newer versions of the Access drivers:
    odbc_conn_str = 'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=%s;UID=%s;PWD=%s' %\
                    (db_file, user, password)
    
    conn = pyodbc.connect(odbc_conn_str)
    

