Access MDB Data Structures

[visualAd]

I have been given a corrupt Access database by my work (very nice of them). Its corrupt to the point that the database won't even open with an error message of:

The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

I have tried all the normal methods of data recovery in Access such as Compact and Repair, Import, copying it to a new file and even a small utility made by MS, but to no avail. In the end I found an open source library called MDB tools which managed to open the database and give me access to some of the tables; unfortunately nearly half a dozen tables cannot be opened and the library "although tells me that they exist" complains they cannot be found when I attempt to open them.

Is there any way I can find the binary specifications for MDB / Jet files? More specifically the table / record structure (its definitely there when you look at the file in a HEX editor). I know that MS have opened up some of their file formats recently (not sure weather this is one); but if there are any online resources it would be much appreciated. I could probably reverse engineer the MDB tools code but after having a quick glance at it yesterday it looks like it might be a long tedious task and will only do that as a last resort.

[dmaruca]

It's proprietary, so you're very unlikely to find something form MS. Your best bet would probably be to head over to openoffice.org and check out what they have going. Check this and this out.

[Siddharth Rout]

Hi Visual

If the data is not confidential then could you please upload it. I have few softwares to repair Access MDB Data Structures.

Let me see if I can do something about it...

[visualAd]

Hi Visual

If the data is not confidential then could you please upload it. I have few softwares to repair Access MDB Data Structures.

Let me see if I can do something about it...

Sorry; no can do. What software are you using though?

[Siddharth Rout]

Sorry; no can do. What software are you using though?

I have Kernel Access Repair, and one more. I don't recollect the name...

By the way did you try the inhouse repair tool? if no then try this...

http://209.85.175.104/search?q=cache...nk&cd=10&gl=in

or

http://www.freevbcode.com/ShowCode.Asp?ID=1024

If you don't want to upload the file, you can email it to me, if you want...