I am using a table to store temporary information. The application
frequently empties and reloads the data in the table from a table bound to
the table. The problem is, the app grows like crazy. I watched a 4MB app
grow to 987MB in one session earlier. I am hoping that someone might offer
a better method of doing this. Questions:

I am emptying the table with "DELETE FROM TempTable". Is there another
method of doing it that might contribute less to bloat?

Is there any way to delete a table that has an open form bound to it? Some
way to unbind the form temporarily?

I'm rather desperate to solve this, it is causing major problems. I've
toyed with crazy notions of counting reloads and forcing a compact every X
reloads. The users would hate that.

Any suggestions appreciated,
Randy Harris

"Randy Harris" <randy@SpamFree.com> wrote in message
news:S0Xtc.94$le.68@newssvr15.news.prodigy.com...[color=blue]
> I am using a table to store temporary information. The application
> frequently empties and reloads the data in the table from a table bound to
> the table. The problem is, the app grows like crazy. I watched a 4MB app
> grow to 987MB in one session earlier. I am hoping that someone might[/color]
offer[color=blue]
> a better method of doing this. Questions:
>
> I am emptying the table with "DELETE FROM TempTable". Is there another
> method of doing it that might contribute less to bloat?
>
> Is there any way to delete a table that has an open form bound to it?[/color]
Some[color=blue]
> way to unbind the form temporarily?[/color]

Well, this question is moot. I was able to unbind the form by altering the
RecordSource. Then I was able to delete and recreate the table. However,
it did me no good. It seems Access doesn't recover the space when a table
is deleted, until it is compacted. An exercise in futility.

I'm still hoping that someone might have an idea for another approach to the
problem.

Randy Harris
[color=blue]
> I'm rather desperate to solve this, it is causing major problems. I've
> toyed with crazy notions of counting reloads and forcing a compact every X
> reloads. The users would hate that.
>
> Any suggestions appreciated,
> Randy Harris
>
>[/color]

"Randy Harris" <randy@SpamFree.com> wrote in message
news:ZYXtc.16608$eH1.7156104@newssvr28.news.prodig y.com...[color=blue]
> Well, this question is moot. I was able to unbind the form by altering[/color]
the[color=blue]
> RecordSource. Then I was able to delete and recreate the table. However,
> it did me no good. It seems Access doesn't recover the space when a table
> is deleted, until it is compacted. An exercise in futility.
>
> I'm still hoping that someone might have an idea for another approach to[/color]
the[color=blue]
> problem.[/color]


Place your temporary table in a separate database. Tony Toews has a sample
at http://www.granite.ab.ca/access/temptables.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)