[python-win32] Issue with PythonCOM - Application.Run does not work for Access.Application

[Christoph J. Dorner]

All,

I found in the archives an answer I could not find in my inbox.
Thanks to Tim Roberts!

So far Idid the instantiation via the database mdb-file and I did not do
an EnsureDispatch call on the Access Application object.
I tried this in my code and - voila - got an error that makepy could not
read the library.
I did a manual ensureDispatch for Access.Application from a Python
console and got the following:

Traceback (most recent call last):
   File
"F:\WinPython\WPy64-3950\python-3.9.5.amd64\lib\site-packages\IPython\core\interactiveshell.py",
line 3441, in run_code
     exec(code_obj, self.user_global_ns, self.user_ns)
   File "<ipython-input-3-ffd005a20a26>", line 1, in <module>
     app = win32com.client.gencache.EnsureDispatch("Access.Application")
   File
"F:\WinPython\WPy64-3950\python-3.9.5.amd64\lib\site-packages\win32com\client\gencache.py",
line 531, in EnsureDispatch
     mod = EnsureModule(tla[0], tla[1], tla[3], tla[4],
bForDemand=bForDemand)
   File
"F:\WinPython\WPy64-3950\python-3.9.5.amd64\lib\site-packages\win32com\client\gencache.py",
line 388, in EnsureModule
     module = GetModuleForTypelib(typelibCLSID, lcid, major, minor)
   File
"F:\WinPython\WPy64-3950\python-3.9.5.amd64\lib\site-packages\win32com\client\gencache.py",
line 263, in GetModuleForTypelib
     AddModuleToCache(typelibCLSID, lcid, major, minor)
   File
"F:\WinPython\WPy64-3950\python-3.9.5.amd64\lib\site-packages\win32com\client\gencache.py",
line 559, in AddModuleToCache
     SetTypelibForAllClsids(mod.CLSIDToClassMap)
AttributeError: module
'win32com.gen_py.4AFFC9A0-5F99-101B-AF4E-00AA003F0F07x0x9x0' has no
attribute 'CLSIDToClassMap'

With Excel it works without error.

I am wondering if this might be the issue Tim mentioned earlier
regarding Python 64bit and Office / Acccess 32bit ?
https://code.activestate.com/lists/python-win32/12574

Best regards
Christoph


Am 17.09.2021 um 09:26 schrieb Christoph J. Dorner:
> Hi there,
>
> I need to call Office / VBA applications form a running Python script.
> While calling VBA from Python using Application.Run works with EXCEL,
> it does not work with ACCESS. What I do:
> I link to the Office application via the win32com.client dispatch
> mechanism as usual and I can see the application object in the Python
> debugger.
> If I do an excelapp.Run('xxx") everything is fine.
> If I do an accessapp.Run('xxx") it throws an error -2147352562 which
> win32api.FormatMessage states is an issue with the number of
> parameters. But that cannot be the case as the UDF has no parameter
> and I do not pass any (additional) parameter.
> Moreover I simulated this accessapp.Run call from EXCEL in VBA and
> there it works.
> Moreover, I did a "passthrough" via EXCEL i. e. called a stub in EXCEL
> VBA using excelapp.Run in Python which itself calls ACCESS VBA via
> Application.Run as well. This works for ACCESS VBA code I cannot call
> directly from Python. It even works to create/pass back VBA object
> references from ACCESS via EXCEL to Python.
>
> I could not find any information ont hat issue and I wonder if this is
> an issue related to pywin32 / PythonCOM ? I was told this is a support
> request and not an issue.
> Happy to learn if anybody else knows this problem and what to do.
>
> Thanks in advance
> Christoph
>
>