[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