jwcolby
jwcolby at colbyconsulting.com
Mon May 19 12:09:01 CDT 2008
I rarely use arrays, in fact this combo callback is the only time in years. I use collections extensively (as does Access in fact), and virtually always use a key. If I need to use an index (PKID for example), I convert the index to a string using cstr, then use the resulting string as the key. I find arrays are just inefficient enough to not bother with them. What with all elements having to be the same data type (and thus so often ending up a variant), the fact that you have to do custom programming to speed up inserts / deletes etc. Collections rock, and classes stored in collection rock even more. If you look behind the scenes in Access, EVERYTHING is stored in collections, and I do mean EVERYTHING!!! All of your DAO stuff, collections of recordsets, forms, reports, fields, properties... you name it. If it is good enough for Access... John W. Colby www.ColbyConsulting.com Michael R Mattys wrote: > I found an article on this: > http://msdn.microsoft.com/en-us/library/e1ad18x6(VS.80).aspx > > Michael R. Mattys > MapPoint & Access Dev > www.mattysconsulting.com > > ----- Original Message ----- > From: "Heenan, Lambert" <Lambert.Heenan at AIG.com> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Monday, May 19, 2008 12:26 PM > Subject: Re: [AccessD] Max rows columns in an array > > >> You may be right that huge arrays are slow to manipulate when you need to >> use Redim Preserve (never had to find out myself), but is that >> disadvantage >> at least partly offset by the speed with which one can access an element >> in >> the array? How do Collections compare with Arrays for random access to the >> elements? I'm pretty sure that a linked list will be on the slow side, but >> not sure about Collections. >> >> Lambert >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael R >> Mattys >> Sent: Monday, May 19, 2008 12:15 PM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Max rows columns in an array >> >> I've never heard of it. >> >> However, long before you've reached theoretical limits, you'll have >> switched >> over to collections or linked lists. >> >> Redim Preserve on a large array is like manipulation of a 500 mb bitmap >> with >> limited RAM. >> >> Michael R. Mattys >> MapPoint & Access Dev >> www.mattysconsulting.com >> >> ----- Original Message ----- >> From: "jwcolby" <jwcolby at colbyconsulting.com> >> To: "Access Developers discussion and problem solving" >> <accessd at databaseadvisors.com> >> Sent: Monday, May 19, 2008 11:48 AM >> 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 >>> >> -- >> 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 >> >