S simeon Apr 30, 2004 #1 does anyone knows how can i calculate the size of my tables or the size of any other object? thank you in advance
does anyone knows how can i calculate the size of my tables or the size of any other object? thank you in advance
T TC Apr 30, 2004 #2 No easy way, given that Access (really, Jet) stores data in variable-length records - not fixed-length ones. Maybe write a short program to determine the average length of each field in all records of the table, then multiply by the # of records? Anyway, why do you care? What are you trying to achieve? HTH, TC
No easy way, given that Access (really, Jet) stores data in variable-length records - not fixed-length ones. Maybe write a short program to determine the average length of each field in all records of the table, then multiply by the # of records? Anyway, why do you care? What are you trying to achieve? HTH, TC
