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?"
Compact & Repair: https://599cd.com/acb4
Text Field Sizes: https://youtu.be/tQWOpbvq-OA
Short Text v. Long Text: https://youtu.be/yqctePIteXk
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video 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.
MEMBERS ONLY VIDEO:
BECOME A MEMBER:
Open Another Database: https://599cd.com/shellex
Sleep Function: https://599cd.com/sleep
Compact & Repair: https://599cd.com/compact
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
FREE Customer Template Database: https://599cd.com/XCDT
FREE Access Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Email Me: firstname.lastname@example.org
ms access short or long text, short text vs. long text, choosing field types
Please feel free to post your questions or comments below. Thanks.