Solved

How to find a missing index on a table

Posted on 2013-06-28
5
366 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
ID: 39284991
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
ID: 39285016
yes this is a mix medium database - ODBC, SQL pass thrus, etc.

K
0
 
LVL 77

Expert Comment

by:peter57r
ID: 39285049
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
ID: 39285374
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
ID: 39317922
thanks
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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 …

786 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