I have encountered an overrun problem working with an Access recordset in an Excel VBA program (I'm using ADO). The recordset is large (1,000,000 values) but the Loop that I use to run through the recordset can't get much past 32,700 values (I get a Run-time error "6": Overflow). Am I approaching one of the upper limits of the recordset (I haven't found any documentation for this)? I am creating the recordset from a SQL string, which works OK within Access. Here's the code string that loads the recorsdet:
rst.Open "SELECT (Table).(Field) FROM (Table);", cn, adOpenForwardOnly, adLockReadOnly, adCmdUnknown
Any suggestions would be appreciated.
Thanks.
rst.Open "SELECT (Table).(Field) FROM (Table);", cn, adOpenForwardOnly, adLockReadOnly, adCmdUnknown
Any suggestions would be appreciated.
Thanks.