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:
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.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.
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.![]()




Reply With Quote