Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


MS Access 2003 database grew to 2 gig overnight and crashed

Posted on 2013-01-03
Medium Priority
Last Modified: 2013-11-02
I have an access database that suddenly grew to 2 gig and failed, as it only has 300 records plus sub tables in it it must have corrupted. I performed a compact and repair on it and revived it so it is now working again however its still 2 GIG in size and I am afraid it will crash again.

Does anyone know how to shink it ?
Question by:CtexAndy
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
LVL 77

Assisted Solution

peter57r earned 750 total points
ID: 38739290
Create a new empty database.
Import eveything from the existing database.

File >getExternalData>Import

Author Comment

ID: 38739316
I do not know how to create a new one of the same structure how can I empty an existing old copy of the database?
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 38739350
The method Peter57r suggests will bring in tables with the same structure (it may not bring in any relationships but I suspect there is a system table you can import with that). I susggect you try to determine what caused this or do you have a datatype that is causing this? Access 2010 will allow 4Gb databases, and if you use SQL Server express (free) you can get to 10Gb databases (SQL Server 2008r2 and above). Full SQL Server and you're into the Terrabyte range.

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.


Author Comment

ID: 38739418
If I upgrade to 2010 will I need to do anything to the DB itself as in convert it or will it be directly read as is?

I have somebody writing an SQL version for me so only looking for a short term fix right now.
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 38739452
Open the mdb in Access 2010, then use the Home menu and choose Save & Publish and save database as an accdb. Access will do the rest and then use the newly created accdb instead of the mdb.


Author Comment

ID: 38739461
thanks for your assistance
LVL 61

Expert Comment

ID: 38739464
Does your database have any code or macros creating temporary tables, importing data for reports etc...?

If so, I'd take a look at the data generated by such processes and see whether anything is amiss (such as a routine for calculating/formatting data for a report going into an infinite loop).
LVL 48

Expert Comment

by:Dale Fye
ID: 38739814
How about attachments?

Are you storing other files (Word, Excel, jpg, ...) in the database? If so, you might want to consider storing those in a folder on your network, and simply storing the path to those files in your database.  2G gets used up pretty quickly if you are storing files in the data.
LVL 26

Accepted Solution

jerryb30 earned 750 total points
ID: 38740463

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

A small collection of useful tips and tricks for Windows 10 users that I decided to write as a result of recent questions that were asked and answered at Experts Exchange. Two short video tutorials included. Enjoy..
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

721 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