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.
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…