Peter's Software
Helping you create better Microsoft Access applications

Tip: Reduce Your Microsoft® Access® Database to its Smallest Possible Size

If you compact your Access database on a regular basis, then you are doing a good job of making sure that your application performs efficiently, and that the database file doesn't grow too large. But there are some secrets to reducing your code database size and increasing efficiency that go beyond simple compacting.

In his article "Working with Large Program Databases in Access 97", Cary Prague describes the six steps to large database success which include importing all objects into a new database, and making use of the undocumented /decompile command-line option.

I highly recommend that you read this article, or at least the summary if you want to understand how to get the most out of your database application.