see table size?

[JaredTaylor74]

Is there a way to view the size of a table in access? i have several tables and i want to see how much space they are taking up, either in the database or in general.

Thanks,
Jared

 

[lupins46]

Nope.
Manual calculation can give you a very rough estimate.

 

[JaredTaylor74]

how do i manually calculate it?

 

[lupins46]

You should be able to find field size rules in Help (look at datatypes). You'll have to add up the field sizes and then multiply by the number of records. But bear in mind that all text fields are only as big as the data, not the declared field size.

 

[PHV]

And what about the index size ?