How to determine object sizes

[Rick]

Is there a way to determine the sizes of the various objects within the
..mdb/.mde? I have something driving my total size to 12mb (tables have been
split out) and I think it may be some graphics in my splash screen or menu
but can't determine which.

Thanks for your help.

.... rick

 

[Dirk Goldgar]

Is there a way to determine the sizes of the various objects within
the .mdb/.mde? I have something driving my total size to 12mb
(tables have been split out) and I think it may be some graphics in
my splash screen or menu but can't determine which.

Thanks for your help.

... rick

12MB is not really very large, but if it seems out of proportion the
most likely culprit is indeed some graphic element. That's because
Access stores even ostensibly compressed graphics formats as fully
expanded bitmaps.

Unfortunately, there is no way I know of to determine the stored size of
an object short of compacting the database, checking the size of the
..mdb, then copying it, deleting the object from the copy, compacting the
copy, and comparing the size of the copy with the size of the original.
This is not something you'd want to do for all objects in the database,
but it may be practical if you already suspect certain objects.