[AccessD] Collection limitations

JWColby jwcolby at colbyconsulting.com
Thu Jan 18 09:58:33 CST 2007


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
 



More information about the AccessD mailing list