asked on

View SQL via ODBC? - Corrupt mdb

Two days after I finished the development of my Access database (housed on a network drive), the file went corrupt, and I can no longer open it in Access ("AOIndex" error). I've tried all the recovery tricks, and I've come to face the fact that it's nonrecoverable. My backup copy was 4 days old, so I've got 2 days worth of work to recover. (I know, I should have immediately saved a copy upon completion. Lesson learned.)

Luckily, I can still communicate with the database via ODBC. I've already recovered all the tables and data. I guess I'm out of luck with the forms, but is there a way to somehow view the SQL code of the queries using ODBC?

Any ideas?

ASKER CERTIFIED SOLUTION

jjafferr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cotton9

ASKER

I actually cannot read it from Access, only with ODBC. When I try importing a table into a new mdb, after entering the password, I get : "'AOIndex' is not an index in this table" twice.

Anytime I attempt to open in Access I get the same error.

jjafferr

This page shows how to recover, try it

http://www.e-tech.ca/001-AccessFAQ.asp

jaffer

SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cotton9

ASKER

So I'm guessing that there's not an easy way to view SQL w/ ODBC.

Thanks for trying to help. I'm already familiar with both the suggested website and JetComp, neither did the trick.

I found a trial version of AccessRecovery ($399.99) that limits its functionality by recovering everything, but not showing the recovered forms & reports. It recovered all the queries perfectly! That's what I needed. I've already got the data & tables from ODBC, so I'll just have to rebuild a few forms (unless I can find a trial that limits everything but forms).