Re: Recordset in Memory

If you are using standard Access MDB then I know of no way to do what you have
asked other than using an array to hold the information or using a temporary
database and tables in that temp db. Both ideas have been suggested to you already.

SO, your statement is apparently correct.

Michael wrote:
>
> So, I gather, there is no way to accomplish what I want. Is that correct?
>
> Michael
>
> "Douglas J. Steele" wrote:
>
> > Consider putting your temporary tables in a temporary database.
> >
> > Tony Toews shows one way of doing this at
> > http://www.granite.ab.ca/access/temptables.htm
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no e-mails, please!)
> >
> >
> >
> > "Michael" <Michael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:C8454DBF-11B1-441B-829B-03C0700E91F7@xxxxxxxxxxxxxxxx
> > > Since I run these procedures on a regular basis, I just have temporary
> > > tables
> > > set up for this purpose and delete all the records each time I need to,
> > > but
> > > the database gets bloated. For example, my .mdb file is usually 11MB, but
> > > after running this process once, it grew to 123MB - eventhough all the
> > > temporary records had been deleted. I have to compact the .mdb each time
> > > to
> > > get it back to it's normal 11MB size.
> > >
> > > I was just wondering if there's a way to populate a recordset in memory,
> > > use
> > > it, and then remove it from memory when done without having to store it to
> > > a
> > > table first. I don't think an array would work because the number of
> > > records
> > > I need for the temporary recordset is different each time.
> > >
> > > Thanks,
> > >
> > > Michael
> > >
> > > "Brian Stoll via AccessMonster.com" wrote:
> > >
> > >> I haven't tried it, but can't you delete a table from code? When you're
> > >> done using it, IE: in the Exit_someThing_someFunction, you could delete
> > >> the
> > >> form you created...
> > >>
> > >> Sorry, I don't know of a way to do it all in memory - unless you save all
> > >> the fields in the recordset as a variable, then you aren't creating a new
> > >> table, just a bunch of variables.
> > >>
> > >> --
> > >> Message posted via http://www.accessmonster.com
> > >>
> >
> >
> >
.

Relevant Pages

  • Re: Fastest way to get most common number in array
    ... "Michael C" wrote in message ... on the data this will give out of memory errors even possibly ... on an array with only 2 or 3 elements ... I just happened to spot your comment about memory usage while I was quickly browsing through the threads and I thought you were saying that you were against any code that uses more memory than it really needs to, which of course is something I do not agree with. ...
    (microsoft.public.vb.general.discussion)
  • Re: Anyone know a lame aioe.org forger?
    ... "Michael A. Terrell" wrote: ... arrays Cherry Semiconductor or GEC/Plessey used to have back ... also claim to have an array. ...
    (sci.electronics.design)
  • Re: Use of implicit split to @_ is deprecated
    ... Michael Holzt: ... Offensichtlich verwendet split das Array ... Unverständlich ist mir hingegen, wieso zum Zwischenspeichern ... Vielleicht wird das in Perl 6 ja konsistenter gelöst sein. ...
    (de.comp.lang.perl.misc)
  • Re: Coverage Calculation Speed in VBA, VB, C# and C++
    ... know better is to declare an array that has say, 13,983,616 elements ... With Michael' s code I will add an array or vector to flag the blocks ... Modify it to check any wheel and see what you think of the speed. ...
    (rec.gambling.lottery)
  • Re: Array-Variable auf Inhalt prüfen
    ... Michael Schwimmer schrieb am 29.04.2004 ... >> undefinierte Anzahl von WErten im Array handelt. ... > End Sub ...
    (microsoft.public.de.excel)