View table size

[VegaLA]

Hi all,
this could well be a bit of a weird request so bare with me.
I would like to view the table size (in KB, not records) and I would have thought the Detail view in the Table tab would take care of this for me (i'm sure it used to, i'm using Access XP now) but I cannot get that particular view column to show. I want to see the file size for both Access tables and SQL tables that are linked in.

Anyone have any ideas ?

Thanks in advance,
Mitch....

 

[T.Smith]

There's really no way to view the file size for an individual object. Access was not built with that feature. What you can do is create a new database and import the table to get the approximate table size.


Toby

 

[VegaLA]

Thanks for that Toby, strange that they can't/don't provide that info on the Details view.

Mitch.......