How to reduce the size of MS Access database file?

General discussion on MS Access and its databases.

How to reduce the size of MS Access database file?

Postby janny@me » Sat Nov 03, 2012 6:18 am

I'm using MS Access 2003. I have some large-sized .mdb files. Whenever I open them MS Access takes a lot time. I've heard about decompile but never used it. All I need to reduce the size of my .mdb files to increase the start-up performance. Is there anyone who knows something about this? :)
janny@me
 
Posts: 18
Joined: Wed Oct 31, 2012 11:08 am
Location: New Zealand

Re: How to reduce the size of MS Access database file/

Postby forforumsysinfo » Sat Nov 03, 2012 7:07 am

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.
  1. On the Task bar, click on Start > Run (if you are using Win7 you may directly open it by pressing Win+R).
  2. 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.
  3. Your file will be started decompiling automatically.
  4. Now Compact and repair your database.
  5. Open your database file, now press Alt key + F11 to switch to VB Editor.
  6. Click on Debug > Compile.
  7. 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.
Regards. :)
N. Semm
Site Administrator
To know more about Data Recovery Services, visit SysInfoTools Data Recovery & Email Management Services.
forforumsysinfo
Site Admin
 
Posts: 158
Joined: Sun Mar 21, 2010 10:32 pm
Location: United Kingdom

Re: How to reduce the size of MS Access database file/

Postby janny@me » Sat Nov 03, 2012 7:09 am

Many thanks for this information. I'll try it. :)
janny@me
 
Posts: 18
Joined: Wed Oct 31, 2012 11:08 am
Location: New Zealand


Return to MS Access- Help Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron