• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 486
  • 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
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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