How to find Size of tables in Database

[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?

 

[Pat Hartman \(MVP\)]

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.

 

[Jeff Boyce]

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