Solved

How do I make a access database smaller?

Posted on 2006-07-03
7
818 Views
Last Modified: 2012-05-05
I have an access database that started out at like 50mb and now its about 850mb and when I delete some thing out of the tables it doesn't reduce in size. Any suggestions?
0
Comment
Question by:Herb Vasquez
7 Comments
 
LVL 5

Expert Comment

by:MageDribble
ID: 17030873
Compact the database.  It's under the tools menu
0
 
LVL 5

Expert Comment

by:MageDribble
ID: 17030878
Tools...Database Utilities...Compact and Repair

What happens is Access will "bloat" when tables are created but won't release that memory after the table has been deleted.  You need to compact and repair to release that memory.
0
 
LVL 65

Accepted Solution

by:
rockiroads earned 125 total points
ID: 17030881
In addition to compacting, decompiling also helps. I tend to use this, though always backup first!

Straight after a decompile, a compact/repair is done (I usually do this twice)

http://www.granite.ab.ca/access/decompile.htm
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 5

Expert Comment

by:MageDribble
ID: 17030905
I believe decompile only works well on older versions of Access.  I may be wrong about that though.  

rockiroads, do you know if decompile should be used on newer versions of Access?  I may need to add that feature to my software then :)
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 17030915
You need to do a compact  and repair on a regular basis.  The easiest way to do that is to go to the command menu, select tools>options>general tab>compact on close. Then click ok.
0
 
LVL 2

Author Comment

by:Herb Vasquez
ID: 17030920
THanks
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 17030941
MageDribble, Ive been using decompile on Access2003 (but DB's saved in Access2000) format and so far Ive not had a problem.
But as with decompile, its always safe to make a backup

0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question