"isn't an indes in this table" error

  • Thread starter Thread starter Fred
  • Start date Start date
F

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
 
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
 
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
Click to expand...

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.
 
Fred said:
'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.
Click to expand...

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
 
Back
Top