finding out table size

  • Thread starter Thread starter Paris
  • Start date Start date
P

Paris

I have had no trouble finding out that Access 2000 and 2003 have a 2GB
limit on table size. Now, how does one go about finding out how large a
table is. right click > properties doesn't reveal this

Paris
 
I have had no trouble finding out that Access 2000 and 2003 have a 2GB
limit on table size. Now, how does one go about finding out how large a
table is. right click > properties doesn't reveal this
Click to expand...

It really doesn't matter how big a table is -- it just has to fit inside
the .mdb file. In any case, it's probably meaningless, since it's not
helpful to store a table without its indexes, relational constraints,
property sheets, and so on; which are presumably all scattered throughout
the file. Why do you care how big the table is?

Tim F
 
You could do some maths on the size of a record and multiply by number of
rows - but i seem to remember that there is an analysis tool -
tools->analyze table that should give you what you need.

You may need to install it from the CD if you have not already done so.
 
Back
Top