Compacting MDE Files

[JimA]

How can I compact a MDE Access database upon either retrieving or exiting the application so that the compaction is transparent to the user? As the database grows performance is obviously affected.

 

[elizabeth]

FYI, version 2000 compacts automatically when the user exists, according to the documentation. I always use these features as an excuse to my boss to upgrade...

 

[bitbrain]

Compacting is an administrative function that you should plan on doing on a regular basis. Schedule a time when you know that people will be off the system. Remember that the database needs to be opened with the "exclusive" option.

 

[elizabeth]

p.s. if you want to keep the file as small as possible, compact twice. MS documentation states that on the first pass, items are marked for deletion and on the second pass they are deleted. strange...