Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

'AOIndex' is not an index in this table

Posted on 2004-08-24
11
Medium Priority
?
674 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
11 Comments
 
LVL 51

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 85
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 51

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 85
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
 
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 85
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 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 400 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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

618 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