Working with Access tables and python scripts

Mark Lawrence breamoreboy at
Wed Apr 15 04:23:58 CEST 2015

On 15/04/2015 01:47, Emile van Sebille wrote:
> On 4/14/2015 3:20 PM, accessnewbie at wrote:
>  > 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.
> Yes -- I did so in excel using VB some 15 years ago.  Download and
> install Mark Hammond's win32 extensions.  I don't off the top of my head
> remember the details, but if no one else chimes in I could probably
> dig out that code.
> Emile

People can always ask here also available as

My fellow Pythonistas, ask not what our language can do for you, ask
what you can do for our language.

Mark Lawrence

More information about the Python-list mailing list