I found this in another group try it and see if it works


I had this same problem with a client's database, but found nothing that helped.
So while this topic is a bit old I wanted to find a place to post my solution
where people might see it when searching the Internet. The following VBScript
allows the database to be opened in Access and the table is recreated. However,
once you can open it you may want to create a new database and export/import the
tables in case you have other system table corruptions. Just simply copy and
paste this into notepad and save the file with a .VBS extension. Make sure you
change the Const strDB = "C:\path of MDB. GOOD LUCK!



Jarrett



---------------------- Cut Here -------------------------



Const strDB = "C:\MYDATABASE.MDB"



Dim dbConnection

Set dbConnection = CreateObject("ADODB.Connection")

dbConnection.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & strDB &
";Uid=Admin;Pwd=;"

dbConnection.Execute "Drop Table MSysAccessObjects"

dbConnection.Close

Set dbConnection = nothing



MsgBox "You should now be able to open the database!"





________________________________
From: John Gonnello <johnny100g@...>
To: ms_access@yahoogroups.com
Sent: Saturday, January 10, 2009 9:04:31 AM
Subject: Re: [ms_access] Panic mode !! Database ERROR


Did yo try the database utilities, repair & compress

____________ _________ _________ __
From: Dave R <administrator@ grand-resorts. com>
To: "ms_access@yahoogrou ps.com" <ms_access@yahoogrou ps.com>
Sent: Friday, January 9, 2009 10:01:58 PM
Subject: [ms_access] Panic mode !! Database ERROR

Hi All:

I'm running in panic mode. When I try to open a database I get:

"AOindex not available in this index".

When I click "ok" it exits. The "help" button offers no insight.

Have I lost this DB permanently? ANY help would be appreciated.

=Dave R.=

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]