使用pyodbc连接Access 2007数据库：驱动安装与配置指南

import pyodbc

# 打印所有已安装的ODBC驱动
print("系统上已安装的ODBC驱动：")
for driver in pyodbc.drivers():
    print(f"- {driver}")

# 筛选并检查Microsoft Access驱动
access_drivers = [d for d in pyodbc.drivers() if d.startswith('Microsoft Access Driver')]

if access_drivers:
    print("\n成功检测到Microsoft Access ODBC驱动：")
    for driver in access_drivers:
        print(f"- {driver}")
else:
    print("\n未检测到Microsoft Access ODBC驱动，请检查安装是否成功。")

系统上已安装的ODBC驱动：
- SQL Server
- Microsoft Access Driver (*.mdb, *.accdb)
- Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)
- Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)
- Microsoft Access Text Driver (*.txt, *.csv)
...

成功检测到Microsoft Access ODBC驱动：
- Microsoft Access Driver (*.mdb, *.accdb)

import pyodbc

# 数据库文件路径和密码
# 请将此路径替换为您的Access数据库文件实际路径
db_path = r'E:\MasterMindAcc\Sys\NetNo.accdb'
password = 'AaBbCc' # 如果数据库没有密码，可以将此行留空或删除，并在conn_str中省略PWD部分

# 构建连接字符串
# DRIVER名称必须与pyodbc.drivers()输出中检测到的名称完全匹配
conn_str = f'DRIVER={{Microsoft Access Driver (*.mdb, *.accdb)}};DBQ={db_path};PWD={password}'

conn = None # 初始化连接对象
try:
    # 尝试建立数据库连接
    conn = pyodbc.connect(conn_str)
    print("成功连接到Access数据库！")

    # 在此处执行您的数据库操作，例如查询数据
    cursor = conn.cursor()

    # 示例：查询一个名为'Users'的表中的所有记录
    # cursor.execute("SELECT * FROM Users")
    # rows = cursor.fetchall()
    # for row in rows:
    #     print(row)

    # 示例：根据用户名和密码验证用户
    # username_to_check = 'Admin'
    # password_to_check = 'your_admin_password' # 替换为实际密码
    # cursor.execute("SELECT UserName FROM YourTableName WHERE UserName = ? AND Password = ?",
    #                username_to_check, password_to_check)
    # user_found = cursor.fetchone()
    # if user_found:
    #     print(f"用户 '{username_to_check}' 验证成功。")
    # else:
    #     print(f"用户 '{username_to_check}' 验证失败或密码不正确。")

except pyodbc.Error as ex:
    # 捕获pyodbc特有的错误，例如连接字符串错误、认证失败等
    sqlstate = ex.args[0]
    if sqlstate == '28000': # SQLSTATE '28000' 通常表示无效授权规范（如密码错误）
        print(f"连接失败：密码错误或权限不足。错误信息: {ex}")
    else:
        print(f"连接失败：发生ODBC错误: {ex}")
except Exception as e:
    # 捕获其他非pyodbc的Python异常
    print(f"发生未知错误: {e}")
finally:
    # 确保在任何情况下都关闭数据库连接
    if conn:
        conn.close()
        print("数据库连接已关闭。")