Valid Index Name error message

S

Susan

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?
 
J

Jeff Conrad

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,
 
J

Jeff Conrad

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error copying properties from a linked table to a new access database 0
Corrupt mdb?? 3
"Compile error in table level validation expression " after format 0
objects not visible 8
Cannot open the Access 2007 database 3
strange corruption 6
error message "Operation invalid without a current index" 2
Wierd error message, Please help can't access database 2

Top