Determine object size in a database (tables, forms, etc)

[rustychef]

I've tried searching the internet, but the word "size" brings up too many results...

I want to know if there is a way to calculate the how much space (in KB/MB) a database's tables, forms, modules, etc take up. Its easy to look at the file and see that it is 65MB in size, but which of the tables, forms, etc are taking up the most space? How much?

I am primarily working with MS Access databases (ver 2003)

What I don't need is how to calculate how many records a table has, how to compact/repair a database, or how to get/set the dimensions of a form (there's hundreds of thousands of search engine results for that)

Any ideas will be greatly appreciated!

 

[Remou]

This post may help:

http://www.tek-tips.com/viewthread.cfm?qid=1143787

It is not possible to obtain an accurate size, but an approximation may suit.

http://lessthandot.com

 

[TheAceMan1]

How are ya rustychef . . .

If the db works well as expected (espcially after a compact) ... [red]whats the point?[/red] It won't get any better than this!

Why modify something that works well! . . .

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]