By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,018 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Temp table explosion

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:S0************@newssvr15.news.prodigy.com...
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?
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
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

Nov 13 '05 #2

P: n/a
"Randy Harris" <ra***@SpamFree.com> wrote in message
news:ZY*********************@newssvr28.news.prodig y.com...
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.

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!)

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.