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 <[email protected]>
To: [email protected]
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_acc...@yahoogrou ps.com" <ms_acc...@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]
