Re: py2exe + win32com + DAO

2009-05-14 Thread Trevor
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

Re: py2exe + win32com + DAO

2009-05-13 Thread David Lyon
On Tue, 12 May 2009 22:06:42 -0700 (PDT), Trevor trevor.la...@gmail.com 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

py2exe + win32com + DAO

2009-05-12 Thread Trevor
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

Re: py2exe + win32com + DAO

2009-05-12 Thread David Lyon
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

Re: py2exe + win32com + DAO

2009-05-12 Thread Trevor
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