Access MDB Data Structures
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:
Code:
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. :D
Re: Access MDB Data Structures
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.
Re: Access MDB Data Structures
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...
Re: Access MDB Data Structures
Quote:
Originally Posted by koolsid
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?
Re: Access MDB Data Structures
Quote:
Originally Posted by visualAd
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...
