Access Newbie wrote:
> Is it possible to transfer the results of an Access 2010 query (accdb
> extension) to a python script with the click of a button? Information
> will be used as variables within the script.
>
> Prefer to click button from Access data entry form to execute script
> but it can be from another GUI if necessary.
>
> Data getting transferred (anywhere from 20-50 fields) will be contact
> information, shapefile name and directory location, and arcpy
> parameters such as buffer distances for various geoprocessing
> applications. Script can be run from the command line and does not
> require ArcMap to be open to run.

Well, wait a minute.  You have described several completely different
approaches here.  Are you talking about something that runs inside of
Access, or a GUI app that talks directly to the database, or a
command-line app that pulls from the database?

In order to display an Access form, the Access application has to be
running.  In that case, buttons can call Visual Basic scripts, and it
may be easier to do what you want entirely in Visual Basic.

There are several ways for a standalone application to talk to an Access
database, assuming Access is installed.  However, if Access already has
the database open, you can't necessarily open it in another application
at the same time.

-- 
Tim Roberts, t...@probo.com
Providenza & Boekelheide, Inc.

_______________________________________________
python-win32 mailing list
python-win32@python.org
https://mail.python.org/mailman/listinfo/python-win32

Reply via email to