|
fsandoval -> How to fix a damaged Access Database (2/12/2003 16:06:18)
|
A few weeks ago one of my Access databases was " corrupted" . All I did was download it and opened it in Access and it gave me this message:
' aoindex' is not an index in this table...can' t open database
I don' t know if anybody' s had this problem in the past but anyway I looked all over the net for an answer with the following results:
1.Microsoft said this happens and all I had to do was restore it with my back-up copy of the database (Which, of course, I didn' t have).
2.Someone recommended a program called JetCompact which is supposed to fix this problem, but it also didn' t help.
3. Someone also recommended the " Repair and compact" function within Access. No dice.
In short, I tried everything that was recommended to me with no positive results. So fumbling around on my own I came up with this solution:
1. Open Microsoft Excel and create a new sheet (file)
2. Click on the " Data" drop down menu, select " Get external data" and click on " New database query"
3. select " MS Access Database*"
4. On the " Select Database" dialog browse to where your " corrupted" database is located and open it (double click)
At this point you' ll see a dialog box displaying all the tables in your database under the heading " Available tables and columns"
5. All you do is select your table and click the > arrow to move it over to the " Columns in your query" section.
6. Click " Next"
7. Click " Next" again
8. In the " Sort by" just select the first field on your table (ID, Index, whatever)
9. On the next screen make sure the " Return data to Microsoft Excel" is selected and click " Finish"
10. In the " Where do you want to put the data" screen, make sure that " Existing worksheet" is selected and that " =$A$1" is showing.
11. Click Ok
Now you' ll see your data from that table as a excel worksheet. Save it and you' re done. If you have more than one table in your Access database you' ll have repeat steps 2 - 11 for every table you have
After you' ve recovered and saved your table(s), open Microsoft Access and create a new blank database. Then:
1. Select the " File" drop down menu, select " Get External Data" and then select " Import..."
2. Browse to where your saved Excel data (recovered table) is and import it. I' m assuming you know your way around Access so at this point the rest of the process is quite obvious.
I hope this helps someone out there...have fun!!
Felipe
[image]http://www.frontpagewebmaster.com/upfiles/5920/Mk26644.gif[/image]
|
|
|
|
