Why I Don't Use Compact on Close in MS Access

In this Microsoft Access tutorial, I will show you why I do not recommend using Compact on Close in Access databases. We will learn what Compact and Repair does, when it is safe to use Compact on Close, the risks involved with multi-user and split databases, and discuss best practices for maintaining and backing up your Access files.

Sienna from Syracuse, New York (a Platinum Member) asks: Hi Richard, I've been using Compact on Close in my Access database for years without any issues. It keeps the file small and tidy, and I don't have to think about it. But I've heard you mention in a few videos that you don't recommend using it. Why is that?

Prerequisites

• Compact

Links

• Split Your Database
• Backup Access
• Compact Cmd Line
• Compact VBA

Recommended Courses

• Access Updater
• Access Compactor Template
• Access Backup Template

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 Merch Store - Get your swag here! Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, compact on close, compact and repair, split database, multi-user database, front end back end, database corruption, network database, compact with VBA, schedule compact, automatic compact, database backup, backup template, compactor template, push front end updates, temp tables, command line compact