Re: [python-win32] MS Access query error

2006-03-13 Thread Robert Brewer
Phill Atwood wrote: > intypes.com_error: (-2147352567, 'Exception occurred.', (0, > 'ADODB.Recordset', 'Operation is not allowed when the object is > closed.', 'C:\\WINDOWS\\HELP\\ADO270.CHM', 1240653, > -2146824584), None) IIRC, you need to set Cursorlocation before calling Recordcount. Google

Re: [python-win32] MS Access query error

2006-03-13 Thread Phill Atwood
I'm trying to get at some data in MS Access. This long query updates a table. I'm wondering if this query is failing. Anyways, when I run dbpath = os.getcwd() + "\\Test (2).mdb" conn = win32com.client.Dispatch(r'ADODB.Connection') DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.