temp files blow up mdb

  • Thread starter Thread starter Reiner Harmgardt
  • Start date Start date
R

Reiner Harmgardt

Hi NG

in my Access97-Application i create some temp-files around 30megs which blow
up
very fast my mdb.
Even though i delete them after using.
( i use them for feeding pivot-tables in Excel 2000)

What can i do.
If i just use queries for it, does it solve the problem?

Is there another possibility than compacting the database?

thanks for helping

Regards

Reiner
 
The term is "bloat", not "blow up". A bridge gets blown up, a database
bloats. :-)

I should think that using queries will work -- at least from the bloat
aspect. I have an application that exports a lot of queries to Excel and I
don't see that kind of bloat. Queries just display stored data in a new
way, they don't actually store the data again (which is what is causing the
bloat). The only downside might be performance.

If you want to use tables, I would suggest programmatically creating a
temporary database, create temp tables there, then link them back into your
database, then when you are done, delete the whole temp database. On my
webite (www.rogersaccesslibrary.com) I do something like that for Importing.
In my sample: "ImportToTempDatabase2.mdb", I create a temp database, create
temp tables in the temp database, link them into my real database, do
whatever I need to, then delete the whole temp database. No bloat at all.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top