[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 564
  • Last Modified:

Corrupt 2002 MDB file

I have an access 2002 database that will open but will not compact.  I tried to create a new mdb and import the objects but I get the message that the db is corrupt.    Any ideas would be greatly appreciated!

Thanks,

Bill
0
Bill Ross
Asked:
Bill Ross
  • 5
  • 4
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can also try the external JetComp utility:

http://support.microsoft.com/kb/273956

But decompile would likely work best. Make sure to backup before trying any of this.
0
 
Bill RossAuthor Commented:
boaq,

No go on the decompile.  Still get error message.  VBA project won't open.

LSM,

JetComp link is broken on that page.  Can I get JetComp somewhere else to try it?

Thanks,

Bill
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jeffrey CoachmanCommented:
Create new database and import *one object at a time*
Compact the database after each object is imported.

When the DB fails to compact, you know the cause is the object you just imported.
0
 
Bill RossAuthor Commented:
Hi,

When I try to import into a new db I get a message that the DB is corrupt and the import objects screen won't open.  I'm sending the file to a repair shop http://www.everythingaccess.com/default.htm 
We'll see how it goes.

Bill
0
 
Jeffrey CoachmanCommented:
<When I try to import into a new db>
Import *what* into a new db?

As I stated, ...if you create a new db and import *1 table*...What happens?
0
 
Bill RossAuthor Commented:
Hi,

I created a new db and click File, Get External Data.  Select the DB and the "This db is corrupt and needs to be repaired" message shows.  I cannot select anything as the selection window does not show up.  So I can't import any object.

Thanks,

Bill
0
 
Jeffrey CoachmanCommented:
:-(
Oh, ...
 ...that does sound bad...

Keep us posted
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Wayne and crew over at EA are very, very good. If they can't get it back, no one can.
0
 
Bill RossAuthor Commented:
Hi All,

Latest update.   I sent the file to a www.everythingaccess.com

I got it back repaired and almost complete.  Well worth the $200 as it saved me a day of work.

Thanks for your inputs.

Bill
0
 
Bill RossAuthor Commented:
Solved the problem.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 5
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now