Hi,

I have got into the habit of using module level variant arrays to hold data from ADO recordsets (using the .GetRows method)

I have found that this works quite well.

I am just wondering on the pros / cons of this basically in terms of memory usage / performance?

Will a recordset that is open for the duration of the form being open consume more resources than a Variant Array?

Is it quicker to loop through a Variant Array than a recordset?

Thanks for any tips / suggestions in advance

Dave