Re: Working with Access tables and python scripts

2015-04-14 Thread Mark Lawrence
On 15/04/2015 01:47, Emile van Sebille wrote: On 4/14/2015 3:20 PM, accessnew...@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

Re: Working with Access tables and python scripts

2015-04-14 Thread Emile van Sebille
On 4/14/2015 3:20 PM, accessnew...@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 datab

Re: Working with Access tables and python scripts

2015-04-14 Thread hey . ho . fredl
I don't know how to start a Python script from Access, but you could definitely do it the other way around, reading the Access database from Python. An example: --- import pyodbc ODBC_DRIVER = '{Microsoft Access Driver (*.mdb)}' connstr = 'DRIVER={0};DBQ={1}'.format(ODBC_DRIVER, 'filename.mdb')

Working with Access tables and python scripts

2015-04-14 Thread accessnewbie
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 (o