You may easily reduce the size of your .mdb files by decompiling them. See how you can decompile your .mdb file:
Decompiling is used to remove database's compiles VBA code, but which is unreadable. Though it's safe and effective but however one must take backup of database file and make sure the database file is not opened by any user.
- On the Task bar, click on Start > Run (if you are using Win7 you may directly open it by pressing Win+R).
- Now enter you file name and path in the Run dialog box, for example: msaccess.exe /decompile "C:\Your Path To\YourDBName.mdb", and click on OK.
- Your file will be started decompiling automatically.
- Now Compact and repair your database.
- Open your database file, now press Alt key + F11 to switch to VB Editor.
- Click on Debug > Compile.
- Close the VB Editor. Compact and repair again.
You .mdb file will be decompiled.
Note: You can try this method with all versions of MS Access, from MS Access 95 to MS Access 2010. And, if any error takes place while decompiling fix it.
Hope this information will be helpful.