sql_on_mdb.py

from win32com import client

def process_sql_in_mdb(mdb_file_path: str, sql: str):
    '''
    :param mdb_file_path: Full path to .mdb file
    :param sql: sql query
    :return: row set for db
    '''
    connection = client.Dispatch(r'ADODB.Connection')
    row_set = client.Dispatch(r'ADODB.Recordset')
    row_set.Cursorlocation = 3
    DSN = f'PROVIDER=Microsoft.ACE.OLEDB.12.0;DATA SOURCE={mdb_file_path};'
    connection.Open(DSN)
    row_set.Open(f'[{sql}]', connection, 1, 3)
    row_set.MoveFirst()
    return row_set