How do I know how much space a table uses within an MDB

[MarcelMegens]

Hi there

I would like to know how to find out how much space a table uses within an MDB. is there a analyser of some kind available that you know of?

Thanks

 

[Ron_dK]

Assume you want to know the table size ( in Kb) , I don't think there is any
tool to provide you with that figure. As far as I know, one can only see the Database size.

Maybe this might help :
http://www.databasedev.co.uk/access_specifications.html

 

[MarcelMegens]

I want to find out how much KB space an existing table uses

Yes Indeed, I need to know the (approximate)size of a table so I can determine for which large table I should consider revising/optimizing.

(Hup Holland hup!)

 

[The_Doc_Man]

Using the Tools >> Documenter feature, you can get the size of a single table's record. Using a simple COUNT query, you can get a record count. Those two items give you approximate table size.

However, if you have a LOT of text strings in the database, the only real way to do this is via a query that computes the size of each string (+8 bytes for the string pointer structure) and add in the appropriate number of bytes for each non-string. Then compute the number of bytes for each record individually and sum up that value.

'tain't easy.