I think the problem I am experiencing bears a resemblance to the
content of this post:
http://mail.python.org/pipermail/python-list/2001-February/071421.html
Does anyone know what the GUID for the DAO 3.6 library is (or can
explain how I can find it)?
On May 12, 11:00 pm, David Lyon wrote:
> On
On Tue, 12 May 2009 22:06:42 -0700 (PDT), Trevor
wrote:
> I do not believe your assertion applies to the following line of code:
>
> daoEngine = win32com.client.Dispatch(r'DAO.DBEngine.36')
It doesn't. I'm simply suggesting that it is possible you are opening
the database in Access or something
I do not believe your assertion applies to the following line of code:
daoEngine = win32com.client.Dispatch(r'DAO.DBEngine.36')
The preceding code snippet instantiates a COM object and is
prerequisite to creating a reference to a specific database:
daoDB = daoEngine.OpenDatabase(dbname)
As the
Maybe VB is opening the table in Exclusive mode... then when you
are opening it as a subprocess, it's already locked.
It's possible the win32com module is not giving you a very
descriptive error message.
Try running your process while vb is running at the same time
with the database open and if
I have a Python code module that adds records to a MS Access
database. The following line of code executes successfully when the
code module is run as a Python script:
daoEngine = win32com.client.Dispatch(r'DAO.DBEngine.36')
It also runs successfully when the Python script is compiled and run
as
