Fog Creek Software
Discussion Board




Corrupted Jet Database File

Is anybody out there really good at repairing corrupted  jet databases?

One of the users at our stores accidentally pulled the plug on their PC while working with local ordering data in Access 97 and now the MDB is very unhappy.  Lo and behold, the repair utility in Access won't touch it.

No problem, I thought, I'll just go to the tape backup and salvage a file from last night.  Of course, the backup hasn't been running at that location for the last several weeks.  (No, I'm not the Sys Admin, he's on vacation! :)

Any clever tricks would be greatly appreciated by the poor guy who has to work overtime this weekend re-entering his order data....

Tim Lara
Friday, June 27, 2003

You can use the JetComp utility provided by Microsoft to attempt a repair outside of MS Access.  It will sometimes fix a file which Access can't.

Go to MSDN.Microsoft.com and serach for 'jetcomp'.

Best of luck.  If this doesn't work you may be hosed. 

You do have a backup, right?  :')

Eric Budd
Friday, June 27, 2003

Try the JetComp utility with the Jet 3.5 SP

http://support.microsoft.com/default.aspx?scid=kb;EN-US;172733

For general help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;279334


Good luck - if that doesn't work you are screwed...

DJ
Friday, June 27, 2003

An excellent resource on corruption can be found at:

http://www.granite.ab.ca/access/corruptmdbs.htm

In the above, just skip all the first stuff until you get to :

To retrieve your data

If nothing else, you can always contact Peter Miller. He will repair the database for you at a reasonable cost. There is also a list of other access repair services in the above link.

Check out:
http://www.pksolutions.com/services.htm

Albert D. Kallal
Edmonton, Alberta Canada
kallal@msn.com
http://www.attcanada.net/~kallal.msn

Albert D. Kallal
Friday, June 27, 2003

Thanks for all the help, everyone.  I haven't had any luck so far, but if something works, I'll post what it was.

Albert:  Thanks for the data recovery referral.  In this case, the amount of data that was lost is fairly small, so the cost of recapturing it is probably less than or equal to that of paying the recovery fee, but such a service might come in REAL handy down the road!

Tim Lara
Friday, June 27, 2003

In had this happen several times with fairly large datasets.  I do recall one time when the fix-it utility didn't work. I created another database and was able to import the old tables into the new one.  Another time, that trick didn't work, so I wrote a small module to read the primary data table row-by-row and write it to a new table. That worked up to the point where a row was corrupted, and I was able to recover the majority of it. Other times - nothing worked and I had to resort to the 1 or 2-day old backup copy.

Nick
Friday, June 27, 2003

Back in the days of Access 2, we had an MDB beyond repair. Opened it up in an editor and cleared the first few bytes. Access was then able to repair the MDB.

Also try deleting the LDB file if it still lying around.

db
Tuesday, July 01, 2003

Can Access actually open the database?

I have had corruptions in the indexes that meant I got errors only when view particualr records. Solved by dropping the indexes and recreating them

db
Tuesday, July 01, 2003

*  Recent Topics

*  Fog Creek Home