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?"

Members

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.

•  Extended Cut Video - Silver
•  Database Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

New

• Compact from the Command Line: https://599cd.com/CompactCmdLine
• Compact with VBA: https://599cd.com/CompactVBA
• Access Compactor Template: https://599cd.com/Compactor
• File Already In Use Error: https://599cd.com/FileInUse

Links

• Compact & Repair: https://599cd.com/Compact
• Text Field Sizes: https://599cd.com/TextFieldSizes
• Short v Long Text: https://599cd.com/ShortVLongText
• Open Another Database: https://599cd.com/shellex
• Sleep Function: https://599cd.com/sleep
• Read & Write Text Files: https://599cd.com/file+io
• Get File Size: https://599cd.com/filelen
• Delete a File: https://599cd.com/kill
• Rename a File: https://599cd.com/rename
• Recordsets: https://599cd.com/recordset

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.