Operation Invalid Without a Current Index

[mohsinhq]

hi,

I'm having major problems with my database in that the database has lost all its functionality overnight!

If I click any button it gives me a message about indexes. (indexes1.jpg)

i cant seem to view any tables, queries etc in the database view! (BlankDB.jpg)

When i click a tab i get the message (invalid.jpg)

My understanding of Indexes is minimal so please help

Thanks

 

[The_Doc_Man]

In table design view you can define indexes from the tool bar. Move your mouse over the tool icons until you find the index tool. Click it.

An index has a name, normally associated with the field on which the index is based, but that isn't permanent. If you don't have an index, some operations just won't work. Like, for example, declaring referential integrity on tables that have some data in common. Without an index on the data in the parent table, no relationship can be built. You have obviously found another such situation.

 

[Pat Hartman]

If the db was previously working, it is now corrupted. Try the compact and repair. If that doesn't work, download the Jet utilities from the Microsoft website. If that doesn't work, try the decompile switch (search for details). And last but not least, create a new empty db and import all the objects from the sick db.