Working with Access tables and python scripts

accessnewbie at accessnewbie at
Wed Apr 15 00:20:08 CEST 2015

I have an existing extensive python script that I would like to modify slightly to run a different variation on a process.

I also have all the variables I need to run this script (about 20 in total)stored in an Access 2010 64 bit database. 

Is it possible to create a button on an Access form (or other GUI) to pass the information that is stored in the various fields in the database to the python script? Not all the values are in a single table. A query joining related tables would need to be done. Ideally I would like to execute the script from the Access data entry form immediately after entering the required data into the database.

If so, how might I go about accomplishing this? I am at a loss as to where to even start such a task.

Any and all help greatly appreciated.

More information about the Python-list mailing list