Compacting a FE database

J

Jonathan

I have a front end and backend database. I would expect the BE database to
require compaction every so often because the tables are dynamic. But I also
see the FE database get smaller after being compacted. Why is this so since
its contents are static?

Thanks,
 
W

Wayne Morgan

The work is still being done in the front-end file. That should be where
your queries and code are. Access itself will sometimes need to create
temporary tables to handle some of its operations. These will be created in
the front-end file and will cause it to eventually bloat.
 
R

Roger Carlson

Although this space shouldn't really be considered "bloat". It is the
normal working space that the database needs. After compaction, a FE
database should grow to a certain size and THEN remain relatively static.

However, you CAN get bloat in a FE database under a number of circumstances.
For instance if you create and save a lot of queries in code, this would
properly be termed bloat and might need periodic compaction.

--
--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
 
W

Wayne Morgan

Roger,

You're right. Bloat is probably too strong a word for the normal size growth
for normal Access processes. One item I left out though would be if the user
is creating temporary tables in the front-end in their code. This can
definately cause bloating.
 
Top