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

C

CamFella

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

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

CamFella

CamFella said:
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.
Click to expand...
 
C

CamFella

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