Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 30th, 2006, 06:07 PM
Registered User
 
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Fixing An Overbloated MDB - HELP!!

During development testing, my MDB got to be over 2GB before I caught it. Now Access says the file is corrupted. AAAHHHH!

Can anyone help me fix this file and recover my last few days' work? Please?
Thans,
David

 
Old October 31st, 2006, 08:44 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

How did it get this large? Is it data?

When in development, always set your database to compact on close. That's Tools > Options > General tab, Compact on Close.

Open Access without a database from the program menu. Then select Tools > Database Utilities > Compact and Repair Database. A wizard will open and you can point to the bad database. Then see what happens.

You may also be able to open a new blank database and peek into the tables Insert > Table > Link Table. Then you can off load some of the data if there is too much in there. Move the data to your new database, and then delete it from the old one.

HTH

mmcdonal
 
Old November 13th, 2006, 12:11 AM
Registered User
 
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to thidinh
Default

Try do as mmcdonal's instruction.
If dont success go to
http://www.officerecovery.com/access/download_demo.htm
http://www.everythingaccess.com/acce...baserepair.htm
http://www.pcrecovery.com download free soft Aceess restore.exe (evaluation version)repair it
Cheer!
 
Old September 21st, 2014, 03:38 PM
JeremyHineman
Guest
 
Posts: n/a
Default Access recovery way

Hi! If I were you, the first thing I would try is Compact and Repair. http://www.filerepairforum.com/forum...access-trouble
If that doesn't work, then create a new Web db and import the relevent tables into it and see if you can make the forms there... if so, import the rest of the objects... very often in a corrupt Access db, the objects themselves are all fine, so swapping out the old file for new shiny one is the answer. http://www.access.recoverytoolbox.com/
 
Old October 14th, 2014, 05:59 AM
LawrenceStanl
Guest
 
Posts: n/a
Default

Do you happen to have a backup of your database? If so, the following the instruction:
Restore an entire database
When you restore an entire database, you replace a database file that is damaged, has data problems, or is missing altogether, with a backup of the entire database.

If the database file is missing, copy the backup to the location where the database should be.
IMPORTANT If other databases or programs have links to objects in the database that you are restoring, it is critical that you restore the database to the correct location. If you do not, links to the database objects will not work and will have to be re-created, such as by using the Linked Table Manager.

If the database file is damaged or has data problems, delete the damaged file and then replace the damaged file with the backup.

Or try:
eRepair Access is a powerful Access database recovery solution for damaged *.mdb and *.accdb files created in Access 2000 and above.

For more information: http://access.erepairtools.com/

And the similar question was discussed here: http://www.filerepairforum.com/forum...base-corrupted





Similar Threads
Thread Thread Starter Forum Replies Last Post
import data from mdb to another mdb mat41 Classic ASP Professional 3 March 9th, 2007 07:01 AM
Urgent...need help fixing this error! riki_gill ASP.NET 1.x and 2.0 Application Design 0 October 27th, 2006 08:23 AM
Fixing a Access Database report Belendez Access 2 October 24th, 2006 07:31 AM
HELP! FIXING MY QUERY dstein4d Access 2 January 21st, 2006 03:24 AM
Fixing header, and first column of table. rupen CSS Cascading Style Sheets 5 October 21st, 2005 08:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.