[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