Python Connector for Microsoft Access 관련 정보

Python 애플리케이션에서 Microsoft Access 데이터베이스에 액세스하여 저장된 데이터에 대해 생성, 읽기, 업데이트 및 삭제 작업을 수행할 수 있습니다.

Python Connector for Microsoft Access is a reliable connectivity solution for accessing Microsoft Access databases from Python applications to perform create, read, update, and delete operations on stored data. The solution fully implements the Python DB API 2.0 specification and is distributed as a wheel package for Windows, macOS, and Linux.

Python Connector for Microsoft Access Features

  • Direct Connection - The solution enables you to establish a direct connection to an Access database without installing Microsoft Access or Microsoft Access Database Engine Redistributable on your machine. It supports the .mdb and .accdb file formats, including databases created in the latest Microsoft Access versions, and offers a read-only multi-user mode, enabling several users to read data from a database simultaneously.
  • High Performance - The connector supports a direct connection to an Access database without Microsoft Access Database Engine Redistributable. It also lets you submit multiple update statements to the database for processing as a batch to improve execution time.
  • Fast Deployment - If your Python application must be deployed on multiple user workstations, you don't have to supply Microsoft Access Database Engine Redistributable components for every user since the connector supports a direct connection.
  • Platform Support - The Python connector is available for Windows 32-bit and 64-bit, macOS 64-bit, and Linux 64-bit.
  • Data Types Support - The connector supports all Microsoft Access ASE and Python data types. It offers additional options to control data type mapping between the Microsoft Access data types and Python data types.