|
||||||
|
Compact on Close By Richard Rost ![]() ![]() 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? PrerequisitesLinksRecommended Courses
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
|
||||||||||||||||||||
| |||
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 templ PermaLink Compact on Close in Microsoft Access |