Hi, the problem im having is i have a multitude of tables with many collums but at the minute im using collections to temp store the data whilst the section of the application is loaded but for my first table there are like 8 columns alone and its a bit unpractical to have 8 different collections for each column.

Also i have to tried multi dimensional arrays but with no success as i cant sucessfully re-dim the array with the count of records stored in the Recordset from the sql query.

Any help would be appreciated

Devon