Desperate. Help with Error message

[mghdb]

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.

 

[Fornatian]

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

 

[mghdb]

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

 

[Fornatian]

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.

 

[mghdb]

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?