Question How do I get the size of each Object? (1 Viewer)

[AccessNub]

Hey all,

I have adopted someone elses database. It is a front end with about 100 linked tables/forms/reports/modules. The problem is that the database is really large. I would think by looking at the objects that it should be around 5mb tops, however after compacting it is still 63mb.

Is there a way (vba or otherwise) to look at each object and get its size in KB?

Once I can figure out which object is taking up too much space I can work on making them smaller.

TIA

 

[Ranman256]

63 meg is nothing.
worry about it when its 1.5 gig.

 

[AccessNub]

63 meg is nothing.
worry about it when its 1.5 gig.

If the front end with no tables was 1.5GB I would delete the whole thing and start over. =)

 

[jdraw]

How do you determine when
" object is taking up too much space"?

 

[Libre]

Without exploring all the possibilities, I'll just mention that any graphics - such as a logo or any image at all, on any form or anywhere in your db can quickly double, triple, quadruple, etc, the size of your db. You can get info about the db under the menu DATABASE TOOLS / Database Documenter or DATABSE TOOLS / Analyze Performance. I don't know if these utilities will give you the sizes of individual objects though.

 

[Galaxiom]

The only way I have seen to find the size of objects in a database is to take a copy, remove objects one by one, compact then compare the before and after file size.

I remember seeing a VBA procedure somewhere online to do it.

 

[jdraw]

I have used this to find approximate table sizes.
As Galaxiom said -- take a copy, delete objects 1 at a time, then compact and compare the before and after file size.

I suppose you could create a new database, then import object by object and compact then compare the before and after file size after each import.

What exactly do you hope to gain from the exercise?

If you do decide to do this for all objects, and you are successful, could you please place a copy in the Code repository or the Sample databases.