Table Sizes (2003 SP2)

Is there a way to determine the size e.g., in bytes) of various objects (particularly tables) in an .mdb file? I have a database that tends to bloat very rapidly, but even after compressing it, it's larger than I think it should be. I suspect I have a bunch of indexed fields in a bunch of tables that are probably not necessary. I'd like to attack the big guys first and would like to be able to see if what I'm cleaning up is making a difference in the object size.

Re: Table Sizes (2003 SP2)

I don't think there is a way to do that within the database itself. You could create a copy of the database, delete an object, compact & repair the database, then check the difference in size with the complete database. But if you have many database objects, this would quickly become tedious.

Re: Table Sizes (2003 SP2)

Hans,

Dang. I thought there might be some obscure Size property or something. Oh well. A variation on your suggestion that I think I'll try is to start moving tables over to a backend database and establish linked tables. This way I'll hopefully see how one grows while the other shrinks and still have a functioning database in the process. Probably not a bad thing to do anyway.