Software

Ask something
Discussion Locked

Unable to open an Access 2000 db

0 helpful
5 replies

by vicki.olson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a Access 2000 database that will no longer allow anyone to open it, compact & repair it, import from it, etc. Whenever/however I try to access it, I get the error message "Record(s) cannot be read; no read permission on 'MSysAccessObjects'." Is there a way I can salvage the data in this db? I believe it may happened due to a network connectivity issue but now no one can open it.

5 replies

by benyo

Have you tried setting up a new access databse and using the import utility? You may be able to import data from the corrupted tables. Or maybe try running an import from Excel?!?!

by vicki.olson

I had already tried importing the data into a new db but was getting the same error message. I tried importing into Excel thru Microsoft Query, after your suggestion, and only came up with a few queries and two tables visible, only one of which I could get any data out of - MSysCompactError. Of the 631 error rows, 537 had the same data - ErrorCode: -1022; ErrorDescription: Could not find field 'Description'; ErrorTable: MSysAccessObjects. Any other suggestions?

by joseph moore

Did you try the Repair from the command line?
Open up a Command Prompt and go to where your database is. For example, say C:\Temp\DB1.MDB is it.
Go to that directory, then run:
c:\temp> c:\program files\msoffice\office\msaccess.exe DB1.MDB /REPAIR

Perhaps that will repair it.
Good luck.

by vicki.olson

Thank you for the suggestion but it didn't work either. After trying various other options, I, along with several others on staff, believe the database is irretrievable and will be going to a backup copy. Thanks for trying to help me out, though.:-)

This discussion is closed to new replies.