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.

Files for msaccessdb, version 1.0.0
Filename, size File type Python version Upload date Hashes
Filename, size msaccessdb-1.0.0-py3-none-any.whl (20.3 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size msaccessdb-1.0.0.tar.gz (8.9 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page