database problem - urgent!

[cvaccess]

When I try to open the database it brings up my startup form but when I try to view the tables through the database window I get an error message "Operation invalid without a current index"

When I try to view others...queries,forms I get this other error message " "isn't an index in this table. Look in the Indexes collection of the TableDef object to determine the valid index names."

Help!!! I cannot do anything.

Thank you.

 

[Bastien]

hold down the shift key when the application opens. you will end up in design view...goto your tables and make sure that each table has a primary key, you can also create some indices on the most common lookup element of each table (ie if you have a table of customers, create the primary key on the unique cusotmer ID and maybe create an index on customer name as well)

hth Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[lewatkin]

Hi,

Your problem will probably be found in a corrupt record in one of the tables. TO test this, attempt to Compact and Repair the database. If it will not compact, you have a corrupt record. It is a painstaking search to find that rascal as well. These corruptions are usually caused by the database session ending abnormally - power outage or the 3-fingered salute (Ctrl+Alt+Del). If this continues to be a problem, you may need to develop an alternate method for your users to close your database by disabling all close buttons except the one you want the user to use. The Knowledge Base has free code that you can copy and paste into your app that will assist you in taking care of that problem. When searching for the corrupt record, all that I have seen have had a symbol that looks like the pipe ('|') in one or more fields (usually all of the fields except checkboxes and hyperlinks). I hope this helps.

Lee