Solved

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

Posted on 1998-12-01
8
1,092 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
 
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

895 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now