[AccessD] Collection limitations

That would make sense, and of course is way beyond the actual capabilities
of Windows / VBA to actually use.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Thursday, January 18, 2007 11:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Collection limitations

I believe the limitation is the max value of a Long Integer....

Drew

-----Original Message-----
From: JWColby [mailto:jwcolby at colbyconsulting.com]
Sent: Thursday, January 18, 2007 9:59 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Collection limitations

I have always been under the impression that Collections in VBA could hold a
maximum of 32K objects.  The other day I thought someone said it was
actually 65K.  I just tested and got to ~500K before I broke out of the
code.
 
Does anyone know what the real limitation is?  I thought that it had to do
with using an integer to index in of no key was specified but that appears
to not be the case.
 
John W. Colby
Colby Consulting
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