[AccessD] Max rows columns in an array

I found an article on this:
http://msdn.microsoft.com/en-us/library/e1ad18x6(VS.80).aspx

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "Heenan, Lambert" <Lambert.Heenan at AIG.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Monday, May 19, 2008 12:26 PM
Subject: Re: [AccessD] Max rows columns in an array


> You may be right that huge arrays are slow to manipulate when you need to
> use Redim Preserve (never had to find out myself), but is that 
> disadvantage
> at least partly offset by the speed with which one can access an element 
> in
> the array? How do Collections compare with Arrays for random access to the
> elements? I'm pretty sure that a linked list will be on the slow side, but
> not sure about Collections.
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R 
> Mattys
> Sent: Monday, May 19, 2008 12:15 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Max rows columns in an array
>
> 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
>>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>