Valid Index Name error message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I receive the following message when trying to open an Access 97 database:
"'filename.mdb' isn't an index in this table. Look in the Indexes collection
of the TableDef object to determine the valid indes names." What has happened
and what needs to be done to correct this?
 
in message:
I receive the following message when trying to open an Access 97 database:
"'filename.mdb' isn't an index in this table. Look in the Indexes collection
of the TableDef object to determine the valid indes names." What has happened
and what needs to be done to correct this?
Click to expand...

Sounds like corruption to me. Not good.

Make two backups of this file immediately and review the following
links on my site here:

http://home.bendbroadband.com/conradsystems/accessjunkie/corruption.html

Good luck,
 
in message:
How do I make a backup?
Click to expand...

Make sure you have the database completely closed and if it is a
shared database, make sure everyone else closes as well. Make sure
the residual locking file (LDB) goes away.

Then go into Windows Explorer, navigate to the folder where the
database file resides, and then right click on it. Select Copy from
the list and then Paste the entire file into a new folder like maybe
"CorruptedFileBeforeFixing" (without the quotes). You now have
an entire copy of the database file in a new folder. You might even
want to make another folder as well with a second backup copy.

Then proceed to work through the techniques in the articles I
provided on your original file. This way if something really goes
wrong, you still have some backup copies.

Good luck,
 
Back
Top