I've always been able to fix corrupt databases until now...

[jezebel]

Hi all:
Would appreciate any help that anyone can offer. Have a client with an Access2K database that gives the dreaded "...No read permissions on table MSysObjects..." error. I'm trying to just get the data into a new clean mdb but Access blocks me at every turn.

Have tried compact & Repair
Have tried JetComp
Have tried TransferDatabase via code
No luck, can't get at the data.

Now here's the kicker, the database is the back end to a VB6 application. The application continues to run fine and is happily accessing and updating the database. Any suggestions about alternate ways to get the data into a new clean mdb would be much appreciated.

TIA

John

 

[gemma-the-husky]

I'm sure you've tried all these things, but can you open a new database, and import the tables. Also, Do you have to be in a different work group.

Don't know VB6, but could you amend the VB6 app to copy the tables for you?

 

[allan57]

Try decompiling the db, then compile it then compact/repair it. Make sure that you make a backup first.

 

[jezebel]

Thanks for suggestions:
Definately tried importing into a blank DB, no luck.

Hadn't thought of decompile since its data only. Got very excited and tried. Get the same "No read permissions..." error message.

I'm going to try establishing a dao connection and running a "Select Into" query to make the tables in a new DB.
Wish me luck and certainly, please keep the suggestions coming.

Thank You
John

 

[DataNumen]

Hi John,

You can try our product Advanced Access Repair to repair your Access database. It is a powerful tool to recover data from corrupt or damaged Microsoft Access databases which support to repair Microsoft Access 95, 97, 2000, XP and 2003 databases.

Please visit http://www.datanumen.com/aar/index.htm for detailed information about Advanced Access Repair.

And you can also download a free demo version at http://www.datanumen.com/aar/aar.exe

Alan Chen
DataNumen, Inc. - World leader in data recovery technologies
Website: http://www.datanumen.com
Fax: +1-800-9917-FAX (US Toll-Free), +852-31829286 (HONG KONG)