Compact & Repair
By Richard Rost 3 years ago
Compact & Repair: Why it's Important, How To, How Often?
In this video you will learn about the importance of compacting and repairing your database regularly, exactly what compacting does, how often you should compact, HOW to compact, whether you should use "Compact on Close," tips on compacting over a network, and the efficiency of Access even without compacting.
Patrick from Miami FL (Gold Member) asks, "My database only has a few thousand records in it, but it’s approaching 1 GB in size. What can I do to make this smaller?"
The Extended Cut covers about 3 hours of me building two databases to test the efficiency of short text, long text, compact & repair, and more. See below for a list of all the topics covered in the Member's video.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Subscribe to Compact & Repair
Get notifications when this page is updated