Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Table Sizes (2003 SP2)

    Is this a backend-only databases? That is, no forms, queries, etc.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Table Sizes (2003 SP2)

    Mark,

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

  5. #5
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Table Sizes (2003 SP2)

    >>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.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •