[python-win32] Makepy for Access on Win7

[Vernon D. Cole]

Hartmut:
  If what you are doing is copying data between an ACCESS table and
something else that can be reached from ADO, you might want to consider
doing the entire thing from Python using adodbapi.  You can do that without
even having a copy of Office on your computer.  You can glean the
connection information from your sitepackages/adodbapi/tests folder.
  If, on the other hand, you are controlling ACCESS in some more advanced
manner, then just install the 32 bit versions of Python and pywin32.  They
will work just fine on your 64bit Windows, and will be able to talk to
their 32bit friends via COM.
--
Vernon


On Fri, Mar 8, 2013 at 10:58 AM, Tim Roberts <timr at probo.com> wrote:

> Niemann, Hartmut wrote:
> >
> > I had to switch from Windows XP to Windows 7 and redo my python
> > installation there.
> > I need to generate COM modules for Microsoft products I use.
> >
> > When running makepy on Windows 7 / Python 2.7.3 (64bit) /
> > pywin32-218.win-amd64-py2.7.exe for
> > Microsoft Access 12, I get:
> > ...
> > com_error: (-2147312566, 'Fehler beim Laden der Typbibliothek/DLL.',
> > None, None)
>
> That is 80029C4A, which is TYPE_E_CANTLOADLIBRARY.  You aren't going to
> like this answer.
>
> It looks like you have 64-bit Python, but 32-bit Office.  You can't load
> a 32-bit DLL into a 64-bit process.  Now, most of the 32-bit Office
> components have a 64-bit proxy available to make that crossover, so you
> can invoke them from 64-bit processes.  For whatever reason, it appears
> that Access does not do this.  Even worse, you can't install 64-bit
> Access if you already have 32-bit Office installed.
>
> There is some indication that this might help:
>     http://www.microsoft.com/en-us/download/details.aspx?id=23734
> but I think you are in for some painful Google time.
>
> --
> Tim Roberts, timr at probo.com
> Providenza & Boekelheide, Inc.
>
> _______________________________________________
> python-win32 mailing list
> python-win32 at python.org
> http://mail.python.org/mailman/listinfo/python-win32
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20130308/d9ce1542/attachment.html>