Measuring Individual Table Sizes

[Dwight]

Hello,

I know how to determine the overall size of my database but I think it would be useful to be able to determine the size of the individual components.

For example I have 1 table that is quite big and will continue to grow. Is it possible to quickly check its size?

One obvious solution is to remove the object and measure the overall size before and after. Is there a more direct way?

This is not a crisis or anything so unless there is a quick answer don't burn up brain cells on it.

Thanks,

Dwight

 

[Roni Sutton]

Well, I couldn't stand it.

And I had a few brain cells to burn. I couldn't find anything except the hysterically funny specification that a table can be no bigger than a gigabyte. If my databases get much over 50 megs they corrupt on a regular basis - which may be a function of the number of users and the network. Anyway, I looked through several pieces of documentation and couldn't find anything. Sorry.

 

[Dwight]

I'm quite new to Access and 2 things always amaze me:

1) What is possible

2) What isn't

Thanks for trying. I read "Access specificantions" in the help file.
It has the limits for everything but not how to check them.

 

[Pat Hartman]

You can get a ballpark number by multiplying the recordsize by the number of records. Text fields occupy the number of bytes specified by their length. For other field types, you can find their actual lengths by looking up the data type in help. Don't forget to calculate the size of all indexes also.

 

[Dwight]

Thanks Pat,

Ballpark is all that is needed.

Idon't know if it is against board etiquette to ask for direct assistance but I have an outstanding problem that I would appreciate your guidance on. The thread is titled "A Classic Inventory Tracking Problem"

I wasn't sure how to paste a link but the address is:

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=188724#post188724

If you had a free eyeball I would be indebted. I can provide more background if you need it.

Kind regards,