• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

Database ERROR << TableDef INDEX >>

All Experts, Please HELP to get out of following DATABASE error.

I am getting following error while opening TABLE.

Table location & Name : K:\Soft\4.MDB << On SERVER >>

When I try to open table in the MS ACCESS it prompt to REPAIR table and then give following error.

ERROR :
K:\Soft\4.MDB is not an index in this table. Look in the indexes collection of teh tabledef object to determine the valid index name.

Please sugguest what to do.

It is very urget.

Regards,

Hiren Shah
0
smart2000
Asked:
smart2000
  • 3
  • 2
  • 2
1 Solution
 
sridhar_PJCommented:
Hi,
Better you open the MDB in access and repair the database.
Regards
Sridhar
0
 
n_narayananCommented:
Do you have proper write access in the server?
0
 
smart2000Author Commented:
I try to open the file in the ACCESS but same error it is showing.
Yes, I do have full write access to server.
Even I copy the file on the local drive and try to open using ACCESS but same error.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
sridhar_PJCommented:
Hi,
Open MS Access. Click on Tools menu. Select Database Utilities and select compact and repair Database. Then select the databse. ok
Now i need a clarification. What version MS Access do u have. I am talking about Access2000.
If you try to open in Access97 you will get the same error.
Regards
Sridhar
0
 
n_narayananCommented:
It is better to create the database again, if you know the tables and constraints.

Narayanan.
0
 
n_narayananCommented:
if you still get the problem then send me the database to n_narayanan@yahoo.com, if it is not having any confidential data inside.

Narayanan.
0
 
smart2000Author Commented:
I am usin MS Access 97 I try all the way of recovering data but failed.

Any way thanks for ADVICE, As you all made good friendly effeort to solve by problem, I sugguest you all share point.

Regards,

Hiren Shah
info@smartonnet.com
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now