Recordset in Memory

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Michael" <Michael@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 20 May 2005 23:58:01 -0700

I need to create temporary recordsets which get looped over and over again,
but I don't need to keep the data when I'm done. Is there any way to create
a recordset in memory, then releasing the memory when I'm done, without
having the data saved to a table?

At the end of my processes, my .mdb file gets huge and I have to compact it
each time. I'm using Access 2000.

Thanks,

Michael
.

Follow-Ups:
- Re: Recordset in Memory
  - From: Brian Stoll via AccessMonster.com

Prev by Date: I wish to add recorsets to access table from MS Word VBa Code
Next by Date: Why I cannot Add Records to my database on a network?
Previous by thread: I wish to add recorsets to access table from MS Word VBa Code
Next by thread: Re: Recordset in Memory
Index(es):
- Date
- Thread

Relevant Pages

Re: now that this boring tour is thankfully over...
... >> I didn't think it was a boring tour. ... >memory, except maybe the holiday show 4 years ago... ... Michael ... Prev by Date: ...
(rec.music.artists.springsteen)
Re: What is better?
... > or with recent computers it should be declared as Long? ... byte won't save any memory. ... Michael ... Prev by Date: ...
(microsoft.public.vb.general.discussion)