New Entries Added Almost Daily!
Click here to get on our Mailing List

Compact Repair

Using the Compact/Repair Feature in Access

NEW: Compact with VBA Video
NEW: Access Compactor Template

In this tutorial you will learn how to use the CompactRepair Function.

Reasons to compact regularly: if you do a lot of Import/Export.

Tools > Options

General and checking Compact on Close.

Options -> Current Database -> Compact on close.

	Application.CompactRepair sourceFile, destinationFile
	

	Application.SetOption "Auto compact", True
	

Rick's Thoughts: I personally do NOT like automatically compacting. I've seen databases get corrupted this way. I like to make it a calendar item for myself once a week to (a) backup, and then (b) compact.

See Access Tips.

You can find more about this by searching the website.

Macro

By: Alex Hedley

Click here to sign up for more FREE tips