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
– Erik A, Commented Nov 15, 2022 at 17:02

Gord Thompson · Accepted Answer · 2022-11-15 16:33:34Z

5

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

(I am the maintainer of that package.)

answered Nov 15, 2022 at 16:33

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

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

1 Comment

Gustav Over a year ago

Or: If you need an Access file, don't create it, just write it.

Collectives™ on Stack Overflow

Create MS Access database from a Python app

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related