Object (table, query, form, etc.) Size

[hughesai]

Hi all,

Is there any way to tell how big the various ojects within a database are?
For example, if a db is 20MB, how much of this is made up from each table, query, form, report, macro, or module?.

Reason for asking is that I have a 24MB (compacted) front end database with linked tables (no data held in the database itself) and I want to find out why a handful of queries, forms and reports take up 24MB ! ! !

Thanks in advance,

Aidan Hughes

 

[Steve101]

One thing you might try doing is importing all of the objects to a new database; this may squeeze out some extra space.

One thing to look out for are embedded images in forms and reports. Whilst these may present as small images on the form report (because they are clipped or stretched), they may in fact be physically large (ie. several MBytes). I once fixed an application with a matchbox sized image occupying 4 MB on the main form. Caused a massive overhead on the network; a small amount of image editing reduced the image to 30KB), which dramatically shrunk the MDB and the network traffic.

If you have any images, take a backup of the mdb client, then remove the embedded objects, compact and compare sizes.

HTH

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[hughesai]

I have tried importing everything to a new database and there was little difference in size.

I can't see any embedded images etc. which would be disporportioately large (in fact I can see no images in the forms or reports!).

I'm unfortunately, therfore, no further on.

My original request was for a way of fining out just how big each object in each container is. If I could see individual sizes, it might give me some focus for which objects to work on.

 

[TonyJollans]

Hi hughesai,

I don't think you can directly find out sizes, but as a workaround, if it's just a handful of reports, etc., you might be able to import them one by one into a temporary database and see which element is the problem. I suppose, theoretically, you write a routine to do this for you - might be fun!

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[hughesai]

Hi Tony,

OK - the challenge is set.
I've fallen at the first hurdle - how can you export an object to another database using VBA?

Ant ideas?

Aidan.

 

[TonyJollans]

Hi Aidan,

Excellent! I shall be interested to see how you get on.

Take a look at [blue]DoCmd.CopyObject[/blue].

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.