Hi all. I'm really not sure on which forum this should appear in but I need help with a Error message. I have a database that allows user to delete and enter records. Everything has been working fine until a couple days ago I recieved this error message:

" isn't an index in this table. Look in the Indexes Collection of the TableDef object to determine the valid index names"

I can not see any of my Access Objects. All I get the error message. I've tried everything. Can anyone help or explain to me why this is happening. Thank you for any clarification on this problem.

If you are desperate and will try anything once - try importing everything into a new database - you'll have to rebuild the relationships in the relationships window if you have any and see if that makes any difference.

Ian

I have already tried that, but my tables, queries, forms, etc...does not appear in the import. Any other suggestions.

Other than trying it on another machine to see if it's the specific PC causing the problem I have no idea - the guys who run the forum might. I notice they have a section on recovering corrupt DB's I suppose it depends how important it is to you.

Sorry I can't be of more help.

Thank you for trying. I stumbled onto the solution. I compacted my database and the error message disappeared and my tables, queries, etc...appeared. Not to sure what I did but everything seems to work. But I still want to know what caused this gliche and how I can avoid in the future. Do you or anyone else have any thoughts on the subject?