ms access:tables view: is there a table-size column available ?

[Guest]

in MsExplorer when seeing files one can also see the file SIZE. This is
useful.
However in MsAccess "Tables View" I see no such COLUMN called SIZE.
I need such a column.
When one has numerous tables (for backup and testing purposes) it is
sometimes quite useful in TABLES VIEW to see immediately in TABLES VIEW,
which your TABLE SIZES.

 

[Douglas J. Steele]

There isn't any way to determine the size of a table in Access. How big a
table is depends on how many rows are in it, how big each row is (while you
may define a text field as being 50 bytes wide, it actually only stores as
many bytes as you have data), how many indexes you have on the table and a
few other factors.

 

[Guest]

in MsExplorer when seeing files one can also see the file SIZE. This is
useful.
However in MsAccess "Tables View" I see no such COLUMN called SIZE.
I need such a column.
When one has numerous tables (for backup and testing purposes) it is
sometimes quite useful in TABLES VIEW to see immediately in TABLES VIEW,
which your TABLE SIZES.

 

[Guest]

Can Microsoft introduce such a column "TABLE SIZE" into MsAccess inside the
Tables View so that a user can see immediately HOW BIG various tables are in
terms of # of bytes (without a user manually actually going into the table
and multiplying the # of rows x the record size) ? Thx Doug.

 

[Douglas J. Steele]

Why? It's pretty meaningless.

 

[Guest]

I would beg to differ, strongly.

Thx anyway for replying.