[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
>