DB size increase rapidly

  • Thread starter Thread starter Salome
  • Start date Start date
S

Salome

I have a db of about 27M used by several users. One of the
forms uses several queries to extract data from the db and
creates flat files specified on paths, as requested by the
users. (I replaced the SQL in the form with queries to
increase the speed) If the form was run the db size
increases dramatically to such an extend that if the form
was run twice, the size of the db is 50M. If I compact the
db again, the size returns to normal. It is not an option
to build a compact into the form, as the db has to be
opened exclusively to compact. Is the size increase
normal?
 
Salome

Not normal. Is there a chance there are images involved? A check in
..tablesdbdesign or on Google.com will reveal prior posts on keywords "image"
and "bloat".

Good luck

Jeff Boyce
<Access MVP>
 
Aside from what Jeff stated, I've found that using
MakeTable queries causes significant bloating.

Instead of using MakeTable queries to create temporary
tables, reuse a base table by deleting the contents and
appending new results.

David Atkins, MCP
 
-----Original Message-----
Salome

Not normal. Is there a chance there are images involved? A check in
..tablesdbdesign or on Google.com will reveal prior posts on keywords "image"
and "bloat".

Good luck

Jeff Boyce
<Access MVP>

.
Click to expand...
Thanks for the reply. There is however no images involved -
only queries that extract text from the table to create
the files.
 
Does create query also cause bloat?
I have a few forms that make a tempquery based on criteria they choose. It
starts by deleting the tempquery if it exists, then builds a select statement
and creates a new tempquery? Is this going to be a filesize problem?

JS
(e-mail address removed)
 
Back
Top