access-parser

library0.0.6pypypi✓ verified 84d ago

A pure-Python library for reading Microsoft Access database files (*.mdb, *.accdb) without requiring the Microsoft Access ODBC driver or any external dependencies. Version 0.0.6, released 2024-07-15, maintained irregularly.

database data

pip install access-parser

github ↗package ↗

INSTALL

IMPORT

SIG · ACCESS-PARSER

access-parser

databasepythonv0.0.6

Install

2.6s avg

Import

259ms

Disk

18MB

Pass rate

10/ 10

Env Coverage10 / 10

glibc

3.9–3.13

musl

3.9–3.13

Install & Compatibility

Where this runs

tested against v0.0.6 · pip install

no network on importno background threads

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

py 3.10–3.95 runs

installs and imports cleanly · install 0.0s · import 0.272s · 20.2MB

glibc

py 3.10–3.95 runs

installs and imports cleanly · install 2.6s · import 0.246s · 21MB

18MB installed

● package 18MB

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

AccessParser

✓ from access_parser import AccessParser

✗ from access_parser.access_parser import AccessParser

The library exposes AccessParser directly from the top-level package.

InvalidAccessDBError

✓ from access_parser import InvalidAccessDBError

Custom exception for invalid database files.

Open an Access database and iterate over table rows.

from access_parser import AccessParser # Replace with your .mdb or .accdb file path parser = AccessParser('example.mdb') # Get list of table names print(parser.tables()) # Iterate over rows in a table for row in parser.iter_rows('Table1'): print(row)

Debug

Known issues

breakingRemoved logging configuration on import: In v0.0.6, the library no longer configures logging on import. If your code relied on the library setting up logging, you must configure logging explicitly.

fix

Add your own logging configuration (e.g., logging.basicConfig()) if you need to see library logs.

affects: >=0.0.6

gotchaFile must be a proper .mdb or .accdb file: The library does not handle corrupted or password-protected databases. Trying to open an invalid file raises InvalidAccessDBError.

fix

Ensure the file is a valid, unencrypted Access database.

affects: all

deprecatedPython 3.6 support is not actively tested: The library claims requires_python >=3.6, but newer versions may break on Python 3.6 due to dependency updates.

fix

Upgrade to Python 3.8+ if encountering compatibility issues.

affects: >=0.0.5

gotchaNUL characters in parsed strings: Prior to v0.0.6, strings could contain NUL characters. Upgrade to v0.0.6+ to avoid this.

fix

Update to access-parser>=0.0.6.

affects: <0.0.6

Errors

Common errors & fixes

ModuleNotFoundError: No module named 'access_parser'

The package is installed as 'access-parser', but the import is 'access_parser'. Ensure you installed the correct package.

fix

Run: pip install access-parser

AttributeError: module 'access_parser' has no attribute 'AccessParser'

Incorrect import; trying to import a submodule instead of the top-level class.

fix

Use: from access_parser import AccessParser

access_parser.exceptions.InvalidAccessDBError: File is not a valid Access database

The file is corrupted, password-protected, or not an Access database.

fix

Verify the file is a valid .mdb or .accdb and is not password-protected.

Upgrade

Version history

0.0.6latest on PyPI · released Jan 23, 2025

Audit

Dependencies

No dependency data recorded yet.

Agent activity

191 hits · last 30 days

node

182

ChatGPT (live)

OpenAI (training)

Resources

githubhttps://github.com/ClarotyICS/access_parser ↗

packagehttps://pypi.org/project/access-parser/ ↗