Files keep getting bigger

[K90267000 via AccessMonster.com]

As i use my Database, the file keeps getting bigger after several days even
without much input of data...
until i "SAVE AS" Access 2007...
it will "grow" until 4-5mb....when i "save as" it return back to 1mb plus...
any clues?
thanks!

 

[Guest]

Don't worry about it. It's normal. Access databases need a little internal
wiggle room to work. For example if you sort a query, Access needs to store
this temporary information for a while. The next time that you run a similar
query, this temp space is ready for use.

Think of an Access database file as a paper bag and not a balloon. Once you
open up a paper bag, it tends to keep the same size even though there's
nothing inside it. Compacting or doing a Save As "refolds" the bag; however,
it just opens back up the next time that you use it.

An Access database file can be a maximum of 2 GB which is hunderds of times
larger than the 5 MB of your file. Don't sweat the same stuff.

 

[K90267000 via AccessMonster.com]

great analogy dude!
may i ask further....
I have a FrontEnd linking tables to a BackEnd DB....
the BE consists the purely tables only...will it file size grow? (other then
those caused by increased data)
or only the FE will get bigger?

i should monitor my file size further for the answer, but will be great if i
can know it now..

I dont mind having the FE grow, as u said, its far from limitations, however,
I need my BE to be FTP-ed on a daily basis...so i need its size minimised.

Thanks again! ..paper bag...not balloons...wonderful

 

[K90267000 via AccessMonster.com]

just found from another forumer the following solution...

at access options....current database...compact on close...

will give it a go and see what happens.

great analogy dude!
may i ask further....
I have a FrontEnd linking tables to a BackEnd DB....
the BE consists the purely tables only...will it file size grow? (other then
those caused by increased data)
or only the FE will get bigger?

i should monitor my file size further for the answer, but will be great if i
can know it now..

I dont mind having the FE grow, as u said, its far from limitations, however,
I need my BE to be FTP-ed on a daily basis...so i need its size minimised.

Thanks again! ..paper bag...not balloons...wonderful

Don't worry about it. It's normal. Access databases need a little internal
wiggle room to work. For example if you sort a query, Access needs to store

[quoted text clipped - 14 lines]

 

[Douglas J. Steele]

I'd strongly recommend against using "Compact On Close": it can actually
cause problems. (And it only compacts the FE, not the BE).

You can use the CompactDatabase method of the DBEngine object (assuming you
haven't got any open connections between the FE and BE), or you can set up a
scheduled job to compact the BE before you FTP it.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

just found from another forumer the following solution...

at access options....current database...compact on close...

will give it a go and see what happens.

great analogy dude!
may i ask further....
I have a FrontEnd linking tables to a BackEnd DB....
the BE consists the purely tables only...will it file size grow? (other
then
those caused by increased data)
or only the FE will get bigger?

i should monitor my file size further for the answer, but will be great if
i
can know it now..

I dont mind having the FE grow, as u said, its far from limitations,
however,
I need my BE to be FTP-ed on a daily basis...so i need its size minimised.

Thanks again! ..paper bag...not balloons...wonderful

Don't worry about it. It's normal. Access databases need a little
internal
wiggle room to work. For example if you sort a query, Access needs to
store

[quoted text clipped - 14 lines]

any clues?
thanks!

 

[Guest]

I agree with what Doug says on compact on close. My standard advice is not to
use it. Plus, like Doug says, it will only compact the FE.

Your BE shouldn't grow any more than the data entered if you only have
tables in it. You could manually compact the BE every week or so when users
aren't in it to get rid of extra space.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

just found from another forumer the following solution...

at access options....current database...compact on close...

will give it a go and see what happens.

great analogy dude!
may i ask further....
I have a FrontEnd linking tables to a BackEnd DB....
the BE consists the purely tables only...will it file size grow? (other then
those caused by increased data)
or only the FE will get bigger?

i should monitor my file size further for the answer, but will be great if i
can know it now..

I dont mind having the FE grow, as u said, its far from limitations, however,
I need my BE to be FTP-ed on a daily basis...so i need its size minimised.

Thanks again! ..paper bag...not balloons...wonderful

Don't worry about it. It's normal. Access databases need a little internal
wiggle room to work. For example if you sort a query, Access needs to store

[quoted text clipped - 14 lines]

any clues?
thanks!