how much K/bytes a table/query takes up

[Ian Elliott]

Thanks for any help.
Is there a way in Access when looking at the list of tables or queries to
see how much data they take up? I want to delete some old tables in a
database, but I also want to get an idea of which is taking up how much.
Thanks again.

 

[John W. Vinson]

Thanks for any help.
Is there a way in Access when looking at the list of tables or queries to
see how much data they take up? I want to delete some old tables in a
database, but I also want to get an idea of which is taking up how much.
Thanks again.

Queries take up very little space: the text of the SQL and no more than 64K of
compiled query (anything bigger gets a "Query Too Complex" error.

Tables are trickier. You can add up the stored length of each field, but there
is both constant and variable overhead, the size of the indexes (which are not
to my knowledge publically documented), system table information...

Why does it matter? If you don't need the table, compact the database; note
its size; delete the table, compact the database again, and compare the size.

 

[Ian Elliott]

Thanks John!

Queries take up very little space: the text of the SQL and no more than 64K of
compiled query (anything bigger gets a "Query Too Complex" error.

Tables are trickier. You can add up the stored length of each field, but there
is both constant and variable overhead, the size of the indexes (which are not
to my knowledge publically documented), system table information...

Why does it matter? If you don't need the table, compact the database; note
its size; delete the table, compact the database again, and compare the size.