Quote Originally Posted by Oorang
Erm right but you dimmed it to 2000 (0 to 2000) then looped from 0 to 1999 (So you have an unused element set). Then the first thing your loop adds is "Row0". There is no row 0 :-D
Well I thought it were 2000 rows by 5 columns (my mistake). v_row = 0 is the placeholder for the position in the array, starting at 0. The added value is off course normally the first item in the recordset of the database until the end of the file and not the row = 0.

Basically I would first count the records in the returned recordset after the query, then create an array with that number and fill the array with the records that match the query. Or something like that ...

Charlize