Database Space Hogs

[Question Boy]

Is there a way to quick identify what object are taking to the most space in
the db? For instance images that have been placed on reports or forms that
are unnecessarily taking up space. Or at least which form, I can then look
into it myself to find the cause if need be.

Thank you,

QB

 

[John W. Vinson]

Is there a way to quick identify what object are taking to the most space in
the db? For instance images that have been placed on reports or forms that
are unnecessarily taking up space. Or at least which form, I can then look
into it myself to find the cause if need be.

Thank you,

QB

About the only way to determine how much space an object takes up is to
Compact the database (or a copy of it); note the size of the file; delete the
suspect object; compact again; and compare sizes.

Do note that up until A2007, Access databases bloated very badly if they
contained any images. Apparently the file stored BOTH the original (often
compressed, e.g. jpg) file and ALSO a much larger bitmap version. This has
been fixed in the latest version; but most developers avoided storing images
in databases at all, instead storing a path to a graphic file and using code
to display the image as needed in a Picture control.