Table Sizes (2003 SP2)

Topic

New Reply

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.

Thanks.

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

Is this a backend-only databases? That is, no forms, queries, etc.

Reply | Quote

Mark,

No, it’s a single-user all-in-one database. See my response to Hans.

Reply | Quote

>>it’s a single-user all-in-one database.<<

Well, that's the cause of your bloating. Make sure the "Name Autocorrect" feature is turned off; that will help some. But normal user activities will cause bloating, like running queries.

Reply | Quote