Append query bloat

[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

 

[Jerry Whittle]

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.

 

[Turi]

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.

 

[Jerry Whittle]

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?

 

[De Jager]

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