"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

 

[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