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 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!

New

Access Compactor Template: https://599cd.com/Compactor

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 Access Level 2 for $1.00 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources 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.