如何使用Python在MS Access上单击按钮

pip install pyodbc

import pyodbc

conn_str = r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\path\to\your\database.accdb;'
conn = pyodbc.connect(conn_str)

Private Sub btnClick_Click()
    Dim pythonPath As String
    Dim scriptPath As String
    
    pythonPath = "C:\path\to\python.exe"
    scriptPath = "C:\path\to\your\python\script.py"
    
    ' 调用Python脚本
    Shell(pythonPath & " " & scriptPath)
End Sub

import pyodbc

conn_str = r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\path\to\your\database.accdb;'
conn = pyodbc.connect(conn_str)

def process_button_click():
    cursor = conn.cursor()
    
    # 执行SQL查询或其他数据库操作
    cursor.execute("SELECT * FROM YourTable")
    rows = cursor.fetchall()
    
    for row in rows:
        print(row)
    
    cursor.close()
    conn.close()

process_button_click()