Solved

How do I make a access database smaller?

Posted on 2006-07-03
7
796 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

930 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now