Compact & Repair your Microsoft Access Database - Why it's Important, How to Compact, How Often To

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?"
LEARN MORE:
Compact & Repair: 599cd.com/acb4
Automated Compact Template: • Microsoft Access Autom...
RELATED VIDEOS:
Text Field Sizes: • Optimizing Short Text ...
Short Text v. Long Text: • Short Text v. Long Tex...
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:
• Compact & Repair your ...
BECOME A MEMBER:
/ @599cd
MEMBERS TOPICS:
Open Another Database: 599cd.com/shellex
Sleep Function: 599cd.com/sleep
Compact & Repair: 599cd.com/compact
Read & Write Text Files: 599cd.com/file+io
Get File Size: 599cd.com/filelen
Delete a File: 599cd.com/kill
Rename a File: 599cd.com/rename
Recordsets: 599cd.com/recordset
ADDITIONAL RESOURCES:
FREE Customer Template Database: 599cd.com/XCDT
FREE Access Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Your Questions Answered: 599cd.com/TechHelp
Learning Connection 50% OFF: 599cd.com/Connection
Survey: 599cd.com/survey
Richard's Blog: 599cd.com/blog
Access Forum: 599cd.com/AccessForum
Twitter: / learningaccess
Email Me: [e-mail]
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
ADDITIONAL KEYWORDS:
ms access short or long text, short text vs. long text, choosing field types
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@astrokevin92]

Hi Richard, I'm loving your videos, and I've learned a lot - thank you.
I have a question. I've built a small/medium-sized multi-user database where my users have their own copies of the Access front-end, each accessing external tables hosted as Sharepoint lists. Now I'm assuming that compact and repair is really about efficient use of storage in the back-end, so is there any residual benefit to compacting and repair if the tables are external anyway? And would that mean that each user needs to compact and repair their front-end copies? Thanks.

[@tolefeable]

Thanks

[@599CD]

Welcome

[@robertdsearskn6oqr224]

When I try to Compact and Repair as indicated in your video, I get a "file already in use" error. Even if I open the DB with the Shift key to stop the Opening Window, I still get the error.
As a result I cannot compact the DB. Help!

[@599CD]

Interesting. Try rebooting Windows.

[@lele2171]

I copied pasted data from excel to access (mdb file) and it made my db is so large (not normal increasing like input manually) & it is so slow to execute commands...
I hope this feature will normalize my db file size.
Thank you...

[@bharatbhushan8398]

Is Compact and Repair option availlable in MS Office 2007?

[@599CD]

Yiss

[@ryeshegabriel]

Is compact and repair available in access 2007?

[@599CD]

Yes, indeed!

[@nayyerabbas3957]

Ms access database engine stopped the process because you and another user are attempting changed the sane data at the same time

[@nayyerabbas3957]

Set this plses sir

[@599CD]

Not enough info