Xcessive Database Bloat ?

[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

 

[Fredg]

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

 

[John Vinson]

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.

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.

 

[Matthew Therrien]

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

 

[Roxie Aho]

Take a look at Microsoft Knowledge Base Article - 210100
Roxie Aho