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

On Fri, 27 Feb 2009 08:37:27 -0800, dymondjack wrote:

> 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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com