I built an Access front end this month that I am unable to shrink it. I've tried the following:
Compact and Repair
Transferring all objects (tables, queries, forms...) from the current MDB file to a new MDB file.
No matter what I do, the smallest I can get the file is 50 MB. If I ZIP the file, however, it shrinks it to 1.5 MB. I've embedded some nice JPG images on some forms, but they're all small, around 30 to 40 KB.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.
A Microsoft Access subform is used to show relevant calcul…