Solved

'AOIndex' is not an index in this table

Posted on 2004-08-24
11
641 Views
Last Modified: 2008-01-09
I have an MDB file that will not open.  When trying to open this file, an error pops:  'AOIndex' is not an index in this table.

Link to screenshot of error:  http://danallen.com/299-ReleaseArea/AOIndex.htm

I assume this is a known error, if only I was the one who knew!  lol.  Is there a fix?  I have found some clumsy work arounds online, involving importing all the data into Excel via an UGLY interface called Microsoft Query (ugly for us in this case, not all situations.. hard to resist bashing M$ when there is a braindead Access problem like this one I thought they woulda resolved in like 1997, but I am only a programmer, so what do I know.....  :-D

As always, any information helping resolve and/or explain this issue will be most gratefully appreciated.

-Danimal
0
Comment
Question by:Danimal
  • 5
  • 4
  • 2
11 Comments
 
LVL 50

Expert Comment

by:Steve Bink
ID: 11882790
Sounds like your db has been corrupted.  Here's a link to look at:

http://www.experts-exchange.com/Databases/MS_Access/Q_20967842.html

Look for Nico's checklist for fixing corrupt databases.  A search of the MSKB found nothing of interest on the error message, and I've never seen it before.

In the meantime, could you answer these questions?  Not every day I see an error for the first time.  :)
  a) Can you still use the database at all?
  b) Can you read the offending table?
  c) Can you read the offending table from another database or through ODBC?
  d) Can you query any part of the database externally?
  e) Can you use object import/export on any of the objects?
0
 
LVL 1

Author Comment

by:Danimal
ID: 11882936
a)  Have not found a way to use it yet.

b) Cannot read anything in the offending MDB.  Have tried importing from other Access Dbs, and via ODBC.  I can see the data with M$ Query, but that path would be labor intensive, especially since one of the main tables has more than 64,000 records (Excel's maximum).

c)  no.

d)  yes, from Excel, with M$ Query.

e)  No.
0
 
LVL 84
ID: 11883108
A missing AOIndex means corruption of the system tables, and specifically the MSysAccessObjects table. I'm assuming you've tried JetComp, which works occasionally; however, if this doesn't work the only real option is a data recovery service. You could attempt to read the indexes and try to recreate them (you'll probably want to do this from VB and not Access) but almost certainly you won't succeed.

MSysAccessObjects stores the code behind forms and reports ....
0
 
LVL 50

Expert Comment

by:Steve Bink
ID: 11883202
Wow...so the db is unusable as far as you know.  I'll have to go with LSMConsulting...try the normal routes to repair the corruption.  I hope you have a good backup.  :)
0
 
LVL 84
ID: 11883352
Can you import anything from another db? Can you open a new, blank db and import your forms, one by one, or does it even allow you to do this?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 1

Author Comment

by:Danimal
ID: 11884405
LSM, would it be possible to open a project to help us with this one where we pay to help?  I just got word from my boss ... you read for yourself the email he sent:

***** START EMAIL ************************
Dan (world on cc),

  This is a priority ONE problem, everything else is secondary. I am forwarding this on to Ken & Bob to let them know that there is an issue that may require their help....

Boss (name withheld)

********  END EMAIL ********************
0
 
LVL 84
ID: 11884437
Dan,

Please see my profile for information on contact ...

Thanks,
Scott
0
 
LVL 1

Author Comment

by:Danimal
ID: 11884439
Answers:

Can you import anything from another db?
. not yet

Can you open a new, blank db and import your forms, one by one, or does it even allow you to do this? No.  No access to the database through ODBC or through Link/Import directly to the Access mdb file via the file system in Windows from FILE--GET EXTERNAL DATA.



0
 
LVL 1

Author Comment

by:Danimal
ID: 11884613
LSM,

hehehe

I completed the Quote Request form.  When I submitted it, I got a bomb:  http://danallen.com/299-ReleaseArea/quotebomb.htm

Don't worry, I still trust ya.  I have had one or two web pages bomb before.  LOL

I printed the quote form to a PDF file.  It's a little torqued, but I am hoping you can read it and get in touch to help us through this.
http://danallen.com/299-ReleaseArea/CISProblem.pdf

I'll be working on it, and might solve it before we get in touch, but 'priority 1' means my boss definitely wants the option of additional support, assuming the price is not stupid.  Example of stupid:  $5,000/day plus first class airfare from New Zealand.  Reasonable but sucks:  M$ charges $400 bucks for an incident, but at least you are guaranteed an answer.

-Danimal
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 100 total points
ID: 11884757
Hi Dan,

Looks like my ISP has struck again!!! Thanks ... they moved my site a few days back, and apparently haven't worked out some email issues on the new box.

Meantime, to get the quickest turnaround of your problem, you'll probably want to get in touch with Peter Miller of PKSolutions:

http://www.pksolutions.com/services.htm

He is considered to be just about the best in this field; I can certainly assist you in programming or other areas, and I can help with recreation of indexes, but it appears that this is a critical issue; Peter would be the one to do this most quickly. His rates are reasonable and his expertise unmatched.

I'll be glad to look into it, if you'd like to upload it here:

http://www.thedatabaseplace.net/uploadfiles.asp

and I promise this one won't bomb <g>
0
 
LVL 1

Author Comment

by:Danimal
ID: 11885050
You are my hero for doing this.  I never will forget this excellent, incredibly professional service.  I mean that with deep sincerity.

about the isp.. omg, I had an ISP nightmare when my ISP got bought by INTERLAND!  INTERLAND IS REALLY BAD.  ValueWeb good.  Remember that.   INTERLAND BAD.  ValueWeb GOOD.   For registration:  Network-Solutions (the biggest turnaround in brand quality since Harley Davidson).

Anyway, our worst case scenario is 2-days lost data entry, so the urgency is limited by that.

I have some utilities I will try, then call Peter if still stuck.

Thanks again.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now