View SQL via ODBC? - Corrupt mdb
Posted on 2005-04-24
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?