Create MS Access database from a Python app

Question

I'm working with Python and interacting with a MS Access database via the JayDeBeApi library. Everything works well, I can create tables and all but the file *.accdb need to be created previously in the MS Access software

Is there a way to dynamically create the *.accdb file via my Python code?

Commonly, the rather crude approach to include an empty database with the project and to just copy it to create a new one is used. That also allows you to put things in there and use it as a template — Erik A, Nov 15 '22 at 17:02

score 4 · Accepted Answer · answered Nov 15 '22 at 16:33

4

You can use the msaccessdb package to create the .accdb file.

(I am the maintainer of that package.)

answered Nov 15 '22 at 16:33

Gord Thompson

116,920
32
215
418

Or: If you need an Access file, don't create it, just write it. – Gustav Nov 16 '22 at 10:12

Create MS Access database from a Python app

1 Answers1