Working with Access tables and python scripts

Mark Lawrence breamoreboy at yahoo.co.uk
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 gmail.com 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 
https://mail.python.org/mailman/listinfo/python-win32 also available as 
gmane.comp.python.windows

-- 
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