"isn't an indes in this table" error

[Fred]

I have just started getting the following error when I try
to look at the table (or queries, forms, etc) in my
database:

'D:\Executive Managment.mdb' isn't an index in this table.
Look in the Indexes collecitonof the TableDef object to
determine the valid index names.

I am running Access 97 (government machine). How do I fix
this? How do I even look at the "Indexes collection of the
TableDef object." And then what would I do if I could find
that?

thnx

 

[Arvin Meyer]

First, make a COPY of your database. Second, make another COPY of your
database. Third ...

Only work on a copy. Your MSysObjects is corrupt. You may be able to import
the data into a new empty database.

You may also be able to use Jetcomp.exe to repair it:

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

If all else fails, this is one which Peter Miller of PKSolutions can usually
fix for a small fee.

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

 

[John Vinson]

I have just started getting the following error when I try
to look at the table (or queries, forms, etc) in my
database:

'D:\Executive Managment.mdb' isn't an index in this table.
Look in the Indexes collecitonof the TableDef object to
determine the valid index names.

I am running Access 97 (government machine). How do I fix
this? How do I even look at the "Indexes collection of the
TableDef object." And then what would I do if I could find
that?

thnx

This is a (rather serious) case of database corruption. Your database
is toast at this point I fear; you'll need to restore from a backup.
See

http://support.microsoft.com?id=158933

and get the JET upgrade recommended therein.

 

[Tony Toews]

'D:\Executive Managment.mdb' isn't an index in this table.
Look in the Indexes collecitonof the TableDef object to
determine the valid index names.

Good news. You can likely get your data back intact. Download Jet
3.5 SP 3 and using Jetcomp to repair the MDB. See
http://support.microsoft.com/?kbid=182867 for more information.

For more info on corruption see the Access Corruption FAQ at my
website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews]

http://support.microsoft.com?id=158933

That article is for Jet 3.0 used by A95.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm