Index Name problem

[Guest]

What to do when you receive this message:

"'All termed' isn't an index in this table. Look in the
indexes collection of the TableDef object to determine the
valid index names."

"All termed" refers to the query name and when I try and
go to desing view in reports, forms and queries it does
not allow me to view it or view the results. (I received
the error message and get the option for help or ok.)

I am able to go into the tables and view the data as well
as view the design details.

Thanks in advance for your interest. CC

 

[Arvin Meyer]

You have a corruption which need to be fixed before you corrupt the entire
database. Do the following:

1. Make several copies to work on, stop working on the original database,
you may need it for a recovery service.

2. Do a Compact and Repair from the Tools ... Database Utilities menu.

3. If is cannot be compacted, try using JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;en-us;295334

4. If you haven't done it already, split the database and run everything
except the data from separate workstations. The data may be shared on the
server.

5. Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

6. Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest. Although it's a paid service, Peter Miller does an outstanding job
of saving corrupt databases. Try this URL:

http://www.pksolutions.com

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access