Re: max size of array

From: "Tom Lake" <tlake@xxxxxxxxxxxx>
Date: Tue, 31 Jan 2006 04:01:01 -0500

> I'm trying to fill a 2-dimensional array with ca. 2.000.000 records and
> I'm getting a 'out of memory' error. Is that due to limitations on my
> machine or in VBA or something else?

Are you using Access? If so, why load the records into an array? Access
them (no pun intended) directly from the table.

Tom Lake

.

References:
- max size of array
  - From: Jesper F

Prev by Date: max size of array
Next by Date: fees
Previous by thread: max size of array
Next by thread: Re: max size of array
Index(es):
- Date
- Thread

Relevant Pages

Re: Creating dynamically arrays, is that possible in VBA?
... Do you want to create an array for each ... I have a spreadsheet full of range names. ... Basically I would like to load in VBA all the ...
(microsoft.public.excel)
strange randomization
... User enters any array of numbers beginning in any cell: ... Required: Formula (not VBA, ... Prev by Date: ...
(microsoft.public.excel.programming)
Re: API XML Stream and SW (swDocMgr)
... or VBA with the newer office versions? ... It's all actually trivial to load the XML file into a DataSet/ ... Prev by Date: ...
(comp.cad.solidworks)
arrays
... i have a function that returns an array. ... how do i need the Dim the ... variable so that vba will allow me to have Variable = ... Prev by Date: ...
(microsoft.public.excel.programming)
Re: Beginner 3d model format
... Just export as raw triangles in a text file then. ... in as text and load into an array. ... Prev by Date: ...
(comp.games.development.programming.algorithms)