Ok. After several tries, I think I found out why it breaks and it has
nothing to do with the number of records...
Here is the code/ see notes below:
# code starts here
# First import wincom32 client
from win32com.client import *
# Create the ADO Connection object via COM
Thanks! I will give it a try. It seems though that I get stuck on
rs.Open that makes no sense. I was wondering about pagesize or other
registry settings that might cause this? Will try to track down any
bad data first...
gg
On Mar 19, 3:27 pm, "dsavitsk" <[EMAIL PROTECTED]> wrote:
> Is it possible
Is it possible there is some bad data in the larger db? This is asinine, but
maybe write a small script that adds some data, then opens and closes the
db, then repeats this. If this is a size issue, then you can at least narrow
it down to where the size limit is? And, if it isn't you should be a
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
