import pyodbc
import os

folder = r'c:\fuentes\proyectos delphi\RAUL_ASENCIO\GESTION\documentacion raul asencio\datos\contabilidad'
for fname in os.listdir(folder):
    if fname.endswith('.accdb'):
        fpath = os.path.join(folder, fname)
        conn_str = f'DRIVER={{Microsoft Access Driver (*.mdb, *.accdb)}};DBQ={fpath};'
        try:
            conn = pyodbc.connect(conn_str)
            cur = conn.cursor()
            cur.execute("SELECT COUNT(*) FROM F_CLI")
            cli_cnt = cur.fetchone()[0]
            cur.execute("SELECT COUNT(*) FROM F_PRO")
            pro_cnt = cur.fetchone()[0]
            cur.execute("SELECT COUNT(*) FROM F_MAE")
            mae_cnt = cur.fetchone()[0]
            cur.execute("SELECT DENEMP, NIFEMP FROM F_EMP")
            emp = cur.fetchone()
            print(f"{fname}: Empresa='{emp[0]}', NIF='{emp[1]}', F_CLI={cli_cnt}, F_PRO={pro_cnt}, F_MAE={mae_cnt}")
        except Exception as e:
            print(f"{fname}: Error: {e}")
