Discussion Locked

Determining Table Size in MS Access 97

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
If I have the number of characters that are contained in a row of a table and if i have the number of rows that exist in a table, can i calculate the size of the table in KB/MB?How do i do this calculation?

3 replies

by glen_mcleod

Sum(Length of the columns) * the number of rows in the table.

Integer = 2 bytes
Long = 4 bytes
Text = max length allowed

And so on. The lengths of each data type is listed in the help files for Access.

Glen

This discussion is closed to new replies.