Table size in the access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

How can I know the size of a table inside of the access?

Thanks, nanda
 
Nanda said:
Hi,

How can I know the size of a table inside of the access?

Thanks, nanda

I don't think you can. Did you know that access does not have a limit
on table size, rather the limit is only one the total size of the file (one
or two gig depending on the version)?
 
You can't.

Access uses only the amount of space required. For example, if you have a
field that is of type Text, with the Field Size set to 50, but a particular
record contains only 20 characters, then it uses only 20 characters. That
means that even if you add up the bytes the could be needed for each field
of each record, plus the overhead for each field and each record and the
table itself, you still cannot arrive at an answer.

Further difficulties involved the Unicode Compression setting for each text
field, the fact the BLOB fields such as ,memo, hyperlink, and OLE Object
require pointers and occupy secondary storage, and the inability to know
whether deleted records are occuping space that would be freed if the
database were compacted, and any attempt to calculate the required space
becomes an exercise in futility.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top