How to compact/compressing mdb file

This one should try'n to do when your acces to MDB database file gettin slow

in vba code:
    CommandBars("Menu Bar").Controls ("Tools") & _
    .Controls("Database utilities") & _
    .Controls("Compact and repair database...").accDoDefaultAction

by utility:

• Run Microsoft Visual Basic® for Applications (VBA) code that uses the CompactDatabase method of either Microsoft Jet and Replication Objects (JRO) or Microsoft Data Access Objects (DAO).

Sometimes, these utilities will fail. Microsoft Product Support Services provides an additional, unsupported database-compacting utility named the Jet Compact Utility (Jetcomp.exe), which might be able to recover some databases that the standard compacting utilities cannot. This is because the standard utilities attempt to open and close a database before compacting it. If these utilities cannot reopen the database, compacting cannot proceed, and the database cannot be recovered. The Jet Compact Utility does not attempt to open and close the database before compacting, and may be able to recover some damaged databases that the standard utilities cannot.

DownLoad Jetcomp.Exe Now