[AccessD] Max rows columns in an array

Thanks, that appears to be the case.

John W. Colby
www.ColbyConsulting.com


Heenan, Lambert wrote:
>>From the help file:
> 
> "The maximum size of an array varies, based on your operating system and how
> much memory is available. Using an array that exceeds the amount of RAM
> available on your system is slower because the data must be read from and
> written to disk."
> 
> So that implies that the index is a Long integer to me.
> 
> Lambert 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Monday, May 19, 2008 11:48 AM
> To: Access Developers discussion and problem solving
> 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