[AccessD] Max rows columns in an array

Michael,

 > Redim Preserve on a large array is like manipulation of
 > a 500 mb bitmap with limited RAM.

This is for the combo callback I have been building.  Some lists can be 
long and of course are of unknown number of records, since they cache 
specific fields from a table.

I never do a redim.

John W. Colby
www.ColbyConsulting.com


Michael R Mattys wrote:
> I've never heard of it.
> 
> However, long before you've reached theoretical limits,
> you'll have switched over to collections or linked lists.
> 
> Redim Preserve on a large array is like manipulation of
> a 500 mb bitmap with limited RAM.
> 
> Michael R. Mattys
> MapPoint & Access Dev
> www.mattysconsulting.com
> 
> ----- Original Message ----- 
> From: "jwcolby" <jwcolby at colbyconsulting.com>
> To: "Access Developers discussion and problem solving" 
> <accessd at databaseadvisors.com>
> Sent: Monday, May 19, 2008 11:48 AM
> Subject: [AccessD] Max rows columns in an array
> 
> 
>> Does anyone know what the maximum row / column size is in a VBA Array?
>> Is it an Integer or a Long integer?
>>
>> -- 
>> John W. Colby
>> www.ColbyConsulting.com
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>