nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Launching .exe in python

DanPajak

I am trying to launch microsoft access.exe and have know errors but also no result with opening access. Does anyone know how to do this. I am using ArcDesktop ten with latest service pack and have python 2.6 installed.

import os
os.spawn("c:\programs files\Microsoft office\office12\msaccess.exe")

Find more posts tagged with

Accepted answers

All comments

WesMiller

Luke shouldn't line 4 be

os.system("start MSACCESS.EXE {}".format(filepath))

LukeSturtevant

I know this is an old thread but this seems to work for me:

import os 

filepath = r"C:\project_front.accdb"
os.system("start MSACCESS.EXE {}".format(filepath ))

Thanks Wes, I just updated.

JohnHawkins

I also had this problem but didn't see the answer in where vopgis said he got it to work so I am including a script that I got to work. Note: the popen runs the process in parallel and what I wanted was to finished a process then move on. if you use the subprocess.call(program) it will finish the msaccess call then continue.

import subprocess
def MacroAccess(when):
    if when == 'Nightly': #either Nightly or Weekly
        program = r'"C:\Program Files (x86)\Microsoft Office\OFFICE11\msaccess.exe" "c:\ftp\import2.mdb " /x NightlyBatch'
    elif when == 'Weekly':
        program = r'"C:\Program Files (x86)\Microsoft Office\OFFICE11\msaccess.exe" "c:\ftp\import2.mdb " /x WeeklyBatch'
    else:
        return 'no'
    print when + 'batch'
    subprocess.call(program)
    return when + 'Batch has run'
    print 'done'

print MacroAccess('Nightly')

DanPajak

Thank You very much. I removed the >>> and am now able to launch this from a .py. Thank you all for your help. Had to redu a whole work process because of ArcMap 10 going away with VB. Hopefully creating all the buttons in Python I will not have to change this again.

JasonScheirer

Are the literal >>>s in your script? If so, that's your problem.

DanPajak

I have finally got it to open and run the macro. Thanks again for all your help.

>>> import subprocess
>>> subprocess.Popen([r'C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE',r'\\vopcc\gis\GISOPS\StreetNetwork\Routing.mdb'])

I am having one small issue when I save the file as a .py file type and then double click on the file nothing happens. How do I make this script into a .py file and run the script off of that.

ChrisMathers

This is how I open excel and it works fine. I use a list of arguments separated by a comma. Both are rawed strings.

subprocess.Popen([r'C:\Program Files\Microsoft Office\OFFICE11\EXCEL.exe',r'C:\GIS Projects\TaxChange\Export\Change.xls'])

LoganPugh

Based on the Python help on subprocess, you can (and on Windows, probably should) use a string instead of a list of arguments to specify the command line. Access seems particularly picky about how you specify its command line. This should work:

import subprocess
subprocess.Popen(r'"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "\\vopcc\gis\GISOPS\StreetNetwork\Routing.mdb" /X WSorderMacro')

Note the raw string indicator, single quotes around the entire string, and the double quotes around paths (which are required if the path contains spaces, but it's good to include them anyways).

V_StuartFoote

Jeremy,

Others may have a better feel for it, but it seems a little ambitious to use UNC ref to the \\vopcc\gis mount while working out syntax and function.

To simplify debugging, I would copy or subset the Access MDB to the local file system along with the macro, or at the least Windows map the share.

Finally, I think that the args provided to the Popen need to be separated by commas, but still raw. So wouldn't that be:

subprocess.Popen([r"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE", r"\\vopcc\gis\GISOPS\StreetNetwork\Routing.mdb", r"/x WSorderMacro"])

Stuart

DanPajak

Thanks for you help I finally was able to launch the access from python. I realized that I couldn't just copy and past code. It only worked when I typed it out. Now that I get access to open is there a way to launch a macro from python. I tried

>>> import subprocess
>>> subprocess.Popen([r"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "\\vopcc\gis\GISOPS\StreetNetwork\Routing.mdb" /x WSorderMacro])
SyntaxError: invalid syntax
>>>

and also tried

>>> import subprocess
>>> subprocess.Popen([r"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "\\vopcc\gis\GISOPS\StreetNetwork\Routing.mdb""WSorderMacro"])

Traceback (most recent call last):
  File "<pyshell#41>", line 1, in <module>
    subprocess.Popen([r"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "\\vopcc\gis\GISOPS\StreetNetwork\Routing.mdb""WSorderMacro"])
  File "C:\Python26\ArcGIS10.0\lib\subprocess.py", line 633, in __init__
    errread, errwrite)
  File "C:\Python26\ArcGIS10.0\lib\subprocess.py", line 842, in _execute_child
    startupinfo)
WindowsError: [Error 3] The system cannot find the path specified

and get errors. Thanks again for all your help so far it has been much aprreciated:)

LoganPugh

Windows' file system is case-insensitive by default so it does not matter what case you give to Python. On UNIX-like OS's it may be a different story.

V_StuartFoote

Jeremy,

You've garbled the path again. And others may know for sure, but wouldn't the raw string be case sensitive?

Needs to be as entered as in your 12/30 6:39 post (but with the extra closing ").

Stuart

DanPajak

>>> import subprocess
... subprocess.Popen([r"c:\programs files\Microsoft office\office12\msaccess.exe"])
... 
Runtime error <type 'exceptions.WindowsError'>: [Error 3] The system cannot find the path specified

I get this error. Which is odd because I know the path is correct.

LoganPugh

Don't forget the closing quote. Also the two commands should be on separate lines.

DanPajak

i ran the code in python with in arcmap instead of idle and I get an error.
>>> import subprocess subprocess.Popen([r"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE])
Parsing error <type 'exceptions.SyntaxError'>: invalid syntax (line 1)
>>>

Any ideas on this one? I know it is the correct path.

DanPajak

I corrected the typo and still get nothing. Know error is prompted when I run code in python idle. When I run the code as a .py script it flashes but then access doesn't open.

LoganPugh

Check the path, I simply copied yours and I see a typo in what should be "program files". Using my own path to MSACCESS.exe works for me. It should be throwing an error if it can't find the file though.

DanPajak

I used the code as in your example and still I get nothing to launch. Is there anything at the begining or ending of the python script that I could be missing for this not to work. This is a simple command and works if I put it in command line but nothing in python.

LoganPugh

Two things:
1 - Backslashes are an escape character in Python. Either escape your backslashes with another backslash, put an "r" at the front of the string (just before the opening quote) to denote that it is a raw string, or replace the backslashes with forward slashes.

2 - Use the subprocess module instead, as it is intended to replace other methods of executing external programs.

e.g.

import subprocess
subprocess.Popen([r"c:\programs files\Microsoft office\office12\msaccess.exe"])

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.