Solved

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

Posted on 2014-01-28
6
5,637 Views
Last Modified: 2014-01-29
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.
0
Comment
Question by:CAHB
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 8

Expert Comment

by:chcw
ID: 39816696
You may try

DataNumen Access Repair

at

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

to see if it works for your file.
0
 

Author Comment

by:CAHB
ID: 39816729
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
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 125 total points
ID: 39816817
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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 1

Assisted Solution

by:wayne_phillips
wayne_phillips earned 250 total points
ID: 39817045
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
 
LVL 1

Assisted Solution

by:wayne_phillips
wayne_phillips earned 250 total points
ID: 39817053
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
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 125 total points
ID: 39817353
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

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question