Database Components Size

  • Thread starter Thread starter rudwan
  • Start date Start date
R

rudwan

hi
how do i know teh actual size of each table or form for my
file
because i surprised , i have around 20 forms only (
interface file only ) has 3 MB size
no data no tables
 
It's not practical to calculate these, because there are so many variables.
For example, if you add a good-sized picture to one of your forms, that
alone could increase the database size by 20MB.

Have you tried compacting your database?
Tools | Database Utilities | Compact
 
ok , what about the tables ?
do i can predict its size ? , for example :
if one letter equale to one byte , could i make an
estimated like this
fieldSize * recordcount
 
No, Access is far more intelligent than that.

Just because you have a text field that stores 255 characters does NOT mean
Access uses up 255 bytes for every record. It uses bytes only for the actual
characters that are there.

If the Unicode Compression is not enabled for the field, it uses 2 bytes for
each actual character in the field, but that applies only in Access 2000 and
later. Further, there is some overhead for the table itself, and some
overhead for each field in the table on top of the space to store the data.
This includes 7 bytes for overhead for each record, 1 byte for each
variable-length column plus 1 additional byte for every 256 bytes of total
space occupied by all the variable-length columns, and 1 byte for the
fixed-size columns (yes/no, Number, ...) + the size of the fixed-width
columns (e.g. 4 bytes for Long, 8 bytes for double, 8 bytes for Date/Time, 8
bytes for Currency).

Then if you do have an OLE Object storing graphic data, it starts to get
really messy. So the short answer is: No, not easily.
 
Back
Top