How to create a new database .mdb with Python

Question

Hello I've been searching around and couldn't find anything up to date in this topic.

I would like to create a new .mdb file using pythons library pyodbc.

I've tried so many different ways and can never succeed. The main problem for me is to connect to a database that yet does not exist.

import pyodbc
DRV = '{Microsoft Access Driver (*.mdb, *.accdb)}'
PWD = ''
con=pyodbc.connect('DRIVER={};DBQ={};PWD={}'.format(DRV,'./'+new_path+'.mdb',PWD))

I've tried inserting a

f=open(new_path+'.mdb','a')
f.close()

in order to create a mdb file before trying to connect but could not succeed as well, it says that the file is corrupted.

Well I'm getting blocked to install other libraries, but I'll try it, thanks — Lucas Tonon
– Lucas Tonon, Commented Jun 7, 2020 at 14:03
If it's a permissions issue then try pip install --user msaccessdb — Gord Thompson
– Gord Thompson, Commented Jun 7, 2020 at 14:21

Gord Thompson · Accepted Answer · 2020-06-07 14:45:02Z

2

You can use the msaccessdb module for that. After you

pip install msaccessdb

or

pip install --user msaccessdb

you can simply do

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

answered Jun 7, 2020 at 14:45

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a new database .mdb with Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related