is supposed to be the table name, but it breaks in Python when
you want to open the recordset.
I need to use:
rs.Open('SELECT TOP 300 * FROM [input];', oConn,
constants.adOpenStatic, constants.adLockOptimistic)
as input is an SQL keyword...argh.
Gyula
On Mar 19, 5:17 pm, Gyula &
isn't you should be able to
> figure that out, too. Otherwise, play around with the locking and cursor
> options.
>
> -d
>
> "Gyula" <[EMAIL PROTECTED]> wrote in message
>
> news:[EMAIL PROTECTED]
>
> > Hi there,
>
> > I have been running Py
Hi there,
I have been running Python to tap into an MS Access 2003 database
using ADO (PythonWin+COM). Everything works great creating recordsets
etc. when I open a table with a small number of records. However, when
I try to run the same Python code with a large table (>100,000) I get:
Traceback
