Data storage amount per table?

[dymondjack]

Does anyone know if there's a way to discern about how much of the total mdb
size is taken up by data in various tables?

I have a backend mdb that is growing at a faster rate than expected, and
would be curious to see what total amount of data that each table is holding.

For example... tableA stores 1254kb of data, tableB stores 1.95mb, etc.


Not a huge deal, I was just wondering if there's a property that I haven't
been able to find.

A2K3

Thanks!
--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain

 

[Rick Brandt]

Does anyone know if there's a way to discern about how much of the total
mdb size is taken up by data in various tables?

I have a backend mdb that is growing at a faster rate than expected, and
would be curious to see what total amount of data that each table is
holding.

For example... tableA stores 1254kb of data, tableB stores 1.95mb, etc.


Not a huge deal, I was just wondering if there's a property that I
haven't been able to find.

There is no such property. The closest you might get is to make a
compacted copy of your file, delete the table in question, compact again,
then see how much the file size has changed.