I need a report about table sizes in Access Database. From largest table to smallest.

[RM33]

I am using 2016.



Management wants a report that tells them which table in Access is the biggest and the last time it was updated. The goal is to archive tables that are large and no longer in use. The report should have table name, size and last updated.

How can I produce a report like this.

[isladogs]

You can get approximate sizes of non-system tables but bear in mind these will change as each table is edited and after running a compact and repair.
For info on how it can be done, see Table Size Analysis | Access World Forums (access-programmers.co.uk)
The code's not mine though I did contribute to the thread.