See the Sizes of the Objects in your Databases

Do you have a database that is unusually large and you can't figure out why? The Microsoft Access Object Size Analyzer by Access Learning Zone will allow you to quickly and easily see the sizes of all of the individual objects (tables, forms, reports, queries, macros, and modules) in your Microsoft Access database files.

Videos

•  01. Introduction (3:29) - Free
•  02. User Guide (10:17) - Free

Sample Database

If you'd like to download a sample copy of the database template, you can do so here. This is a non-editable ACCDE version of the template which will let you see it work in action. You will be able to analyze the size of the tables and queries in your database, however you will require the paid version in order to analyze the size of the forms, reports, macros, and modules.

•  Demo Database Download - Free

The sample database requires 64-bit Access 2013 or higher. If you're still using 32-bit Office, read this.

Full Developer Database

Once you have purchased the full developer database template, come back to this page and download the full template. This will give you access to the ZIP file containing the Template ACCDB file. The full version will run on 32-bit or 64-bit Access 2007 or higher. Be sure to watch the User Guide video (above).

•  Full Database Download - Paid

Purchase Template

Please be sure to read the Before You Purchase section below before buying this template.

Features

• Display the size of each object in your database file

Lots of people have asked me over the years if there is a way to determine the size of each of the objects in your database. If you have a very large set of tables or forms they could be taking up lots of space and you don't even know it. Big objects like images and also make your database bloated. So that's where this database analyzer comes in handy. It will scan each of the objects in your database and tell you the exact size is taking up on the disk.

Now that you know which objects are the biggest you can go and optimize them.

Before You Purchase

A few important notes before you purchase this template:

• Please note that this is designed to be a standalone template. If you purchase the database you will get the unlocked source code and you can modify it yourself however the coding in the database is quite complex and I will not support you if you're trying to make changes to it yourself.
• Please watch the User Guide video, above. This template isn't very difficult to use but if you don't follow the instructions carefully you may run into problems. If you post a comment saying that it's not working, and you didn't follow the instructions, I'm going to say "I told you so."
• Backup. Backup. Backup again! The Analyzer opens your database in read-only mode but still there's always the possibility that something gets corrupted so make sure you run a complete backup before you run the Analyzer.
• Remember, we do our best to help you here in the Forums on the website, but technical support is not guaranteed.

Possible Future Upgrade Ideas

If you are interested in any of these, please post a comment below. As I mentioned the coding in this database is pretty complex - like upper level Developer stuff - so I really don't have any plans on making a video that explains how everything was programmed, but if you are interested, and enough other people are interested in seeing this I will make a tutorial for it and include it as a Developer lesson or separate add-on. Post a comment down below if that's the case.

License

For internal use only. This template does NOT come with a royalty-free license. You may only customize the template for your business needs and for use within your organization at one location ONLY. You may not resell or distribute any form of this template to others without express written permission. Contact me for additional information on obtaining a license to distribute if you plan on including this template in a product you are reselling. Additional licenses are required if you plan on using this template with more than ten (10) employees or in multiple locations within your organization.

Not a Finished Product

Please keep in mind that most of my template databases are not designed to be finished products that are ready to go in a working environment. My templates are meant as starting points for you to customize for yourself so you don't have to reinvent the wheel. This requires that you have a basic understanding of Microsoft Access development. To work on most of my databases you should have completed my Access Beginner series and the first couple levels of my Expert series at a minimum. Most of my databases require knowledge of SQL and VBA as well. 

Customize For Your Needs

If you would like to discuss customizing this template for your needs, and integrating it into your current setup, please see my consulting page for details. While I no longer accept custom jobs that are specific to a single user, I may include your features in a future version of this template if they have mass appeal. If you are looking for custom enhancements made to this template just for you, visit my Developer Network.

Technical Support

Please note that technical support is NOT guaranteed for any of my courses, seminars, or templates. If you require help with modifying this template, you may post a question in the Forums, however an answer to your question is not guaranteed. If this template comes with an accompanying Seminar, then you should purchase that Seminar to see how the database was constructed. If not, then you should have taken the suggested courses. Most of my templates are designed on a Developer level and you should have a thorough understanding of SQL and VBA before attempting to modify them. If you have a problem with one of my databases, I will only support the unmodified database exactly as it's downloaded from my site. If you have modified it in any way, it may not be something I can help you with. You can post in the Forums, and I may be able to help you, but if the issue doesn't exist in my unmodified database, it's not something I can support.

Questions?

Got sales or customer service questions about this template? Feel free to contact me. If you have technical "how do I" questions about this template, you discover a bug, or want to suggest a new feature, then please post your comments below.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #template, Microsoft Access object size analyzer template