|
| |
|
|
fsandoval
Posts: 4
Joined: 8/8/2002
Status: offline
 |
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
 Attachment (1)
< Message edited by fsandoval -- 2/12/2003 4:10 PM >
_____________________________
Just letting you know that I know you know.
|
|
|
|
garyb
Posts: 208
From: North Clarendon Vermont USA
Status: offline
|
RE: How to fix a damaged Access Database - 2/19/2003 14:43:59
I' ve often found that if I create a new DB I can import all of the elements in from the old, corrupt database. This is especially true when the problem revolves around indexes etc.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
