Access Table Size (continued) 2

[dianemarie]

How do I determine the size of a table in Access?

 

[930driver]

This came up on an Access list last year. The concensus was that there isn't a simple way.

Working with a COPY compact your database. Record the size. Delete the table. Compact. Check the size. Do the math. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[carrr]

930driver,
Agreed. I've been researching this since dianemarie posted this and I'll be darned if the answer is apparent. I thought that VB would offer a soultion, but there does not seem to be any easier way than what you suggested to accomplish what is being asked. Very strange...

 

[carrr]

Another dirty way to get at the approx. size would be to Save As/Export the table as an Excel file. This takes most of the formatting with it and seems to be very close in approximating the size of the file as it would be in Access. (i.e. On several attempts, the .xls exports and Access .mdb sizes - when containing only one table - were within approx. 20K of each other). Hardly scientific, I know...

 

[dianemarie]

Thanks you two. Very good information and even though not exact science, it's helpful when a user is trying to figure out if a maxed out table is the possible source of their problems.