Question Find memory used by tables, forms etc.

[Islwyn]

I have recently removed a table which was much larger than necessary and replaced it with a smaller table linked to others (which effectively does the same job as the original table). I have also added a handful of new forms and queries to accommodate this change.

As a consequence, the mdb file (which is standalone) has grown by about 25%, which seems to make little sense as there is now a lot less data stored in the tables. I have compacted and repaired the database and also tried decompiling and recompiling it, but this makes no difference to its size.

I want to try and find which parts of the database are the main contributors to this increase without inspecting every form, query etc. visually.

Does anyone know whether there is a way of listing the size of the different components of the database (the size of different forms, reports, tables, queries) using VBA, so I can identify the guilty parties?

Thanks

 

[Galaxiom]

Unfortunately there is no direct way to measure the size of individual objects. I have seen a VBA procedure that does it by copying the database, removing parts and comparing the file size.

Maybe try importing everything into a new database. Perhaps there is something odd that is not being cleared out with the compact.

 

[gemma-the-husky]

but why does it matter?

 

[Lightwave]

May or may not be relevant - I've found that Access is very sensitive to any images being stored within the database. This includes things like even small JPEGs on forms. I would always recommend that you remove these kind of things from the forms if at all possible. I just don't think such images generally are worth the penalty.

Also making runtime version of the database will reduce footprint

 

[mdlueck]

I have found that multiple decompile / compact / compile operations are required sometimes to get all of the air squished out of an Access DB. I have a post with my Rx here: http://www.access-programmers.co.uk/forums/showthread.php?p=1122636#post1122636

Perhaps there is more space to be reclaimed with additional times through the process.