FMS Home Page FMS, Inc.
Microsoft Access Database Compact and Repair to Minimize Corruption and Avoid Bloat (by Access Version)

FMS Development Team Blog

Exploring the Latest in Application Development

About FMS

FMS, Inc. is software development company in Tyson's Corner, VA.
E-mail usSend mail

Recent comments

© Copyright 2013 FMS, Inc.

Microsoft Access Database Compact and Repair to Minimize Corruption and Avoid Bloat (by Access Version)

File server databases like Access/JET MDB and ACCDB files need to be periodically compacted and repaired for optimal performance and to minimize database corruption. This also eliminates database bloat that can occur as data is added and deleted in the database. Here's a Microsoft Knowledgebase article that discusses some of the issues.

Microsoft Access databases can be manually compacted from the Access menu. Unfortunately, over the last few versions of Access, the location of this command has moved around driving Access many users and developers crazy. Read this paper for how performing this critical system administration task across all versions of Access:

Microsoft Access Database Compact and Repair to Minimize Corruption and Avoid Bloat (by Access Version)

 

Currently rated 3.4 by 5 people

  • Currently 3.4/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by Luke on Wednesday, January 12, 2011 11:38 AM
Permalink | Comments (0) | Post RSSRSS comment feed