Hello everybody
I have problem.
I have MS Access database, local MDB file.I'm using VB6. I need read some columns from certainly table. I created ODBC connection for this and in my program I created workspace and connection without problem. All works fine in case that table is smaller, but my table contains around 14000 rows. I created SQL query : SELECT * from MYTABLE and open recordset. Then I go through all rows in the loop and get some data from relevant columns.But on 426th row I got following error "Error 6 Overflow" what means perhaps absence of memory.
I read data by this way for DAO object:
strForName = rsRecorSet!ForName
strSurName = rsRecordSet!SurName ...
In case that I only go through all rows in the loop and dont use this data, all is OK.
I tried DAO and RDO objects but result is same. My aplication crashed on 426 row.
I'm working on Oracle database too and I didn't similar problem with memory.
Note,in case of DAO when I used smaller count of columns(in reading process see above) I crashed on higher number of row. In case of RDO this change hasn't effect.
How to resovle this problem? Can somebody help me?
Dik
