Solved

Record(s) can't be read; no read permission on 'MSysModules2'

Posted on 1998-12-01
8
1,123 Views
Last Modified: 2012-08-13
We have done everything imaginable to recover this MS Access 97 database.  I keep getting that error.  I have even sent this to Microsoft Premier Services and they appear to be stumped.  Repair, Compaction, Jetcomp, Office-2000, and even linking will not extract the data, though I can see that it still exists.  How do I recover the database?
0
Comment
Question by:Cyberchill
[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
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 3

Expert Comment

by:a111a111a111
ID: 1969820
What is the size of the dabase file?
To be continue upon your answer.

0
 
LVL 3

Expert Comment

by:a111a111a111
ID: 1969821
What is the size of the DataBase file?
To be continue upon your answer.

0
 

Author Comment

by:Cyberchill
ID: 1969822
DB size is 11.9Mb
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 5

Expert Comment

by:kulikuli
ID: 1969823
you can use the CopyObject method to create an object with the same contents. Did you try this? Try to copy this table to e.g. "tmpSysErr" to get into the data it contains.
Or open a recordset on the table to output the data from the table to a text-file. If this table turns out to be nothing useful (which I suspect) then delete it. After that try compacting again. There may be something wrong with your indexes that will be repaired then.

0
 

Author Comment

by:Cyberchill
ID: 1969824
Sorry this answer is so long in coming.. The system here keeps rejecting the posting.

Unfortunately, the database cannot open under any circumstances.  Any links to the data fail.  I cannot import any of the objects, even though I can see them.  The problem occurred during a compact from our lan to a local drive during which the network connection failed.

This database was forwarded to Microsoft Premier Support; they were not able to save it.
0
 
LVL 3

Expert Comment

by:dsegard
ID: 1969825
Hi,

Have you found an acceptable solution for that ?
If not, try www.easytools.com. They declare they are able to do miracles in these situation (security problems)
But it's not free...

DS
0
 
LVL 5

Accepted Solution

by:
kulikuli earned 200 total points
ID: 1969826
Get a good developer to extract your data directly from the tables out of your MS Access database into tab-delimited / fixed-width text-files. This can be done by examining the mdb file's structure with a Hex-editor and writing a few procedures to actually extract the data. I can do it for you for a fixed price based on the number of tables/fields. If the data is really worth it I think you should do it.

Best regards,

kulikuli
0
 

Author Comment

by:Cyberchill
ID: 1969827
Great answer, unfortunately I had to rebuild the entire database from scratch.  Let that be a lesson to all to make backup copies!
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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

691 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