Append query bloat

  • Thread starter Thread starter Turi
  • Start date Start date
T

Turi

I have an access database where I use an append query quite often. I will
use this same query over and over by changing the table I'm appending from,
then I save the query. During the save process, the database bloats from
~50KB to ~150KB. Our company recently upgraded to 2007 and that is when I
noticed the problem. Is there a way to stop this from happening? I can
manage it by compacting and repairing after each save, but recently I added 4
tables in one day, so this was a pain.
Thanks
 
Don't even worry about it. An Access file can be up to 2 GB in size. 150 KB
is a drop in the bucket. I wouldn't even worry about doing a compact and
repair until it got over 100 MB or so.
 
The real problem is that my company limits the amount of space I'm allowed on
the drive where it's stored to 500MB and when the database gets over 250MB I
can't compact and repair it.
 
Ouch! Could you move the database file to your PC or a USB flash drive then
compact it? Beg for more disk space due to job requirements?
 
Turi said:
I have an access database where I use an append query quite often. I will
use this same query over and over by changing the table I'm appending
from,
then I save the query. During the save process, the database bloats from
~50KB to ~150KB. Our company recently upgraded to 2007 and that is when I
noticed the problem. Is there a way to stop this from happening? I can
manage it by compacting and repairing after each save, but recently I
added 4
tables in one day, so this was a pain.
Thanks
Click to expand...
 
Back
Top