How to find Size of tables in Database

  • Thread starter Thread starter Robin9876
  • Start date Start date
R

Robin9876

In an Access 2000 database how can you find the size of each table in
the database without having to export every table to a new file?
 
You can find the number of rows by running a query:
Select count(*) as reccount from YourTable; but the actual size of a table
isn't stored any place. You would need to approximate it by multiplying the
record length by the record count.
 
Why? As others have pointed out, Access tables exist only inside an Access
MDB file, so knowing the "size" means very little.

Why do you care? Is this a homework-like question, prurient interest, or is
there something you would want to do if you knew?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top