Repaired Microsoft Access MDE file with "missing MSysDb" error; now receiving "no read permission to MSysObjects" and then to MSysACEs.

Microsoft Access mde file was corrupted.  Started receiving the "missing MSysDb" error.  Could not use Microsoft Access database tool "Compact and Repair", but received same error.  The same happened when trying to export in order to import to a new file.

Used "Access Repair Toolbox" to repair the file.  Afterwards, started receiving the error messages "Record(s) cannot be read; no read permission on 'MSysObjects'." and then "Record(s) cannot be read; no read permission on 'MSysACEs'."

Cannot view mde file in Microsoft Access after receiving these errors.

Have read the other answers to issues with the "missing MSysDb" error, but the recommendations did not work.  Unfortunately, the file was not backed up.
CAHBAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
Contact Wayne at http://www.everythingaccess.com/accessdatabaserepair.htm

If there is any chance it can be repaired  ... Wayne is the one that will be able to do it ... no bs.

Good luck ...

mx
0
 
chcwCommented:
You may try

DataNumen Access Repair

at

http://www.datanumen.com/access-repair/

to see if it works for your file.
0
 
CAHBAuthor Commented:
I actually tried the demo version, as I did with "Access Repair Toolbox".  It said it could, even though it was an mde file instead of an mdb or accdb.  However, I was concerned about paying close to $300 in case it worked like "Access Repair Toolbox" and gave me other issues afterwards.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
wayne_phillipsConnect With a Mentor Commented:
Repairing an MDE or ACCDE file is always going to be trickier than repairing an ordinary Access file.  The reason for this is that when trying to recover from corruption you would typically export as much as you can from the damaged file into a new fresh file, but as I’m sure you already know, you can’t do this with an MDE or ACCDE file since forms, reports and modules are not exportable.  Additionally, the VBA project in an MDE/ACCDE is in compiled form, and to move the VBA project over to the new file requires the source code which is not available.

All of the Access recovery tools work on the same premise of analysing the corrupt file and exporting or re-creating the objects into a new fresh file.  This simply will not work for an MDE or ACCDE format file, as the VBA project can’t be recovered like that.  Some of the tools may recover the form and report designs, but never the VBA code / project of an MDE/ACCDE.

What you need is an in-place repair of the corrupt file (a repair of the damaged file itself rather than trying to export/recreate everything into a new file).  This is much more difficult to achieve, and unfortunately the chances are slim.  It may be possible, but I wouldn’t want to give you false hope without examining the file first.

A more likely possibility would be to reconstruct the VBA project with all source code, using our MDE to MDB restoration service, but again it’s difficult to say whether this would be possible without examining the corrupt file first.

Wayne Phillips [edited by SouthMod]

ps.  Thanks Mx for the recommendation. :)
0
 
wayne_phillipsConnect With a Mentor Commented:
BTW, if you do want me to look at it for you, please use the contact page on my website rather than just uploading your file through the repair service, since your file needs manual attention.  Cheers.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I second the recommendation of www.everythingaccess.com. I've never used their repair service, but have sent a few clients there and they were always very highly impressed with the service and professionalism.
0
All Courses

From novice to tech pro — start learning today.