Valid Index Name error message

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

 

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

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,

 

[Guest]

How do I make a backup?

in message:


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,
--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

 

[Jeff Conrad]

in message:

How do I make a backup?

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,