Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Strange Invalid Index Error Message

Status
Not open for further replies.

ccma

MIS
Oct 23, 2003
23
0
0
US
I'm receiving a strange error message when a database initially opens:
' isn't an index in this table. Look in the Indexes collection of the Table Def Object to determine the valid index names.

The switchboard will come up and am able to enter into the forms and view the data... but when I go to the back end --- where the tables queries are and I click on each tab the same error message comes up and no tables queries forms or reports are displayed in the windows.

Is my DB corrupt?

Thanks in advance.
 
I should add that when I try to repair the database the same error message appears.
 
Try deleting the index(s) and then rebuild them. Then do a db repair.
 
Deffinetly sounds like your indexes are corrupt. pweegar is right on track.

Denny

--Anything is possible. All it takes is a little research. (Me)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top