• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 570
  • 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 CoachmanMIS LiasonCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jeffrey CoachmanMIS LiasonCommented:
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 CoachmanMIS LiasonCommented:
<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 CoachmanMIS LiasonCommented:
:-(
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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