Xcessive Database Bloat ?

  • Thread starter Thread starter Matthew Therrien
  • Start date Start date
M

Matthew Therrien

I was astonished to see my mdb grow by over 9mb when I
added a new report. The report has 1 field and 1 unbound
image control.Properties and code for this report are very
basic.

What is the reason for this ? Just curious.


Regards


Matthew
 
Each time you add an object, make a change, or otherwise do something to the
database, access does not release the space taken, even if you delete an
object.
So, every month, week, day, hour, whatever, compact the database to regain
that space.
Tools + Compact
 
I was astonished to see my mdb grow by over 9mb when I
added a new report. The report has 1 field and 1 unbound
image control.Properties and code for this report are very
basic.

What is the reason for this ? Just curious.
Click to expand...

Access is HORRIBLY inefficient at handling images. If you store
(embedded or linked!) a .jpg file in an image control, it stores the
entire .jpg - *AND* a bitmap of the entire image - *AND* a thumbnail
bitmap - *AND* a bunch of administrative bits and bytes.

A 500k .jpg might well add 9 meg.
 
thanks to FredG and John Vinson - but I am aware of both
points. I am not storing or linking images - I use the
image control merely to upload the image filename. And I
compact all the time.

Regards

Matthew
 
Back
Top