Skip to main content

Create a new empty Access database

Project description

msaccessdb

A package to create a new (empty) Access database. Potentially of interest to pyodbc users who:

  • switched from pypyodbc and miss having the pypyodbc.win_create_mdb method (see Note 3, below),

  • need to create a new Access database so they can dump information into it, or

  • want to create a temporary database to help work around issues regarding performance, prevent "bloat" in the main database, or avoid the dreaded "Operation must use an updateable query." error message.

Installation:

pip install msaccessdb

Usage:

import msaccessdb
msaccessdb.create(r'C:\path\to\new.accdb')

Notes:

  1. This package does not need the Access Database Engine to create a database.

  2. No effort is made to prevent overwriting an existing file.

  3. This package simply creates the file. It doesn't automatically connect to it using pyodbc (or anything else).

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

msaccessdb-1.0.0.tar.gz (8.9 kB view hashes)

Uploaded Source

Built Distribution

msaccessdb-1.0.0-py3-none-any.whl (20.3 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page