Access DB Size
Posted on 2011-02-28
I have an Access DB whose size has gotten to be large, around 12 MB. The data is not in the DB, as it's linked to the tables in the DB where the data resides, so I know it's not the tables/data increasing that's causing it.
To troubleshoot, I went in and deleted all the forms, then the size went down to 11 MB. I deleted all the reports, 10.5 MB, all Queries 10 MB, then all Modules and linked tables, and it went down to 8.3 MB.
How is this possible? I've compacted an repaired and there is absolutely nothing in the DB anymore. No linked tables, no forms, no queries, no VB, no modules, nothing, and it's 8.3 MB!! That means that of the 11 MB original size, 8.3 MB of it is nothing.
I created a blank DB and imported everything into it, and the size was only 2.8 MB. Why is this happening? Is there something I need to do to keep the size down?