Solved

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

Posted on 1998-12-01
8
1,100 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
  • 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Any Way to Print an Import Spec? 3 31
Change date stored as "short text" YYYYMMDD to MM/DD/YYYY? 27 28
Trying to force an answer in a combobox 7 18
Switch 5 17
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

810 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