Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How do I make a access database smaller?

Posted on 2006-07-03
7
Medium Priority
?
983 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 500 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

636 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