[AccessD] Max rows columns in an array

That's confirmed now

Dim BigArray(66000) As Integer
Dim BigggerArray(2147483647) As Integer
Dim BiggestArray(2147483650) As Integer

The third line results in an overflow error when you try to compile. So Long
Integer it is.

Lambert 

-----Original Message-----
From: Heenan, Lambert 
Sent: Monday, May 19, 2008 12:01 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Max rows columns in an array

>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