Search code examples
ms-access

How to determine which table uses the most space in an Access database?

Is there any easy way to determine how much space each table in an Access 2007 database is using?

I have an unusually big Access database and need to find out which table uses the most space. The row counts do not give enough information about the used space.

Solution

  • For functioning Access databases you can get the simple tool Access Memory Reporter 1.0 which shows the amount of memory the tables and indices needs. Note that I haven't tried this tool myself.

    What is your objective once you discover the largest table? How large is your MDB? Have you compacted it recently?

    How much does it shrink when you compact it? That is are you creating and deleting a lot of tables/records in it? If so see the TempTables.MDB page at my website which illustrates how to use a temporary MDB in your app.

    Are you using a lot of graphics in the tables?