Solved

How to find a missing index on a table

Posted on 2013-06-28
5
345 Views
Last Modified: 2013-07-11
During compacting a database, I got and error message stating that an index is missing.  How do I find that missing index?  This is not a database I created, I am totally new to this database.

Thanks,

K
0
Comment
Question by:Karen Schaefer
  • 2
  • 2
5 Comments
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
I am only guessing here.  I have never seen this message in an Access app and I can't imagine how it could arise with an Access table.

So are you linking to any non-Access data sources? That would be my suspicion.
0
 

Author Comment

by:Karen Schaefer
Comment Utility
yes this is a mix medium database - ODBC, SQL pass thrus, etc.

K
0
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
I don't really know how to sort this out but my first attempt would be to use the Linked Table Manager and force a re-linkage of all external tables.
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
Comment Utility
From my one experience with this error here, ...the missing "Index" Access complains about in the error messages may have nothing to do with an actual "Index" on a field in a table you created.

The Index it is referring to may be an Index on a system table or some other aspect of the database file.

This is typically the result of some type of corruption.

*Make a backup" of the database file first*

Then try these basic fixes:
1. Open your VBA editor and compile your code (Debug-->Compile)
2. Create a new database file and import all of the objects from the questionable file into it.
Now try running the compact repair utility

OR...
3. Decompile the database (http://www.fmsinc.com/MicrosoftAccess/Performance/Decompile.asp)
Then try running the compact/repair utility

Hope this helps...

JeffCoachman
0
 

Author Closing Comment

by:Karen Schaefer
Comment Utility
thanks
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

762 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

9 Experts available now in Live!

Get 1:1 Help Now