Cannot open db - MSysAccessObjects error

[Cowper]

Hi,

I converted an existing database from Access XP to Access 2000. After that, it worked OK for a while. Then, suddenly, I cannot open it anymore. Whenever I try to open it, an error message will pop up saying “Record(s) cannot be read; no read permission on ‘MSysAccessObjects’. Could anyone tell me how to fix this problem?

Many thanks

Confused
Cowper

 

[annsolomon]

The file might be damaged. If you haven't made changes to your database and have a backup copy of the file you might be able to delete (after backing up your database, of course) the file and import the backed up copy of the file.

 

[BillPower]

You can try the Decompile function, the syntax is:

"c:\program files\microsoft office\office\msaccess.exe" /decompile "c:\my documents\MyCorruptDB.mdb"

Edit the address to the location of Access 2000 and of course the folder and your DB name.

Otherwise if you haven't a recent backup as annsolomon's suggested, if you've $399 to spare you can purchase AccessRecovery at

http://www.OfficeRecovery.com.

You can download a demo version first to see if can read your DB, if it can you will get a new DB, but the Forms and Reports aren't shown and your Tables will have "Demo" printed in many of your records.

Good Luck!

 

[Cowper]

Hi, annsolomon and billpower

Thank you to you both. I will do what billpower suggested first and take annsolomon's suggestion as a last resort.

But, I have a question for billpower. Could you tell me more about how to use the Decompile function? If the address of my DB is G:\Access Files, what should I do? Should I open MSAccess first and then choose something from the toolbar?

Many thanks

Cowper

 

[BillPower]

Sorry, I should have said.

Click the "Start Button", usually at bottom left of screen, select "Run" and type your edited version of the text below, click run. You should get a message of some sort. Try opening your DB, all I can say is that this works sometimes.

"c:\program files\microsoft office\office\msaccess.exe" /decompile "G:\Access Files\MyCorruptDB.mdb"