How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask WesPCDr Your Own Question
WesPCDr
WesPCDr, Information Systems Manager
Category: Microsoft
Satisfied Customers: 1507
Experience:  Microsoft Office Specialist
21171802
Type Your Microsoft Question Here...
WesPCDr is online now

Unable to open MS Access file

Customer Question

Unable to open MS Access file
Submitted: 1 year ago.
Category: Microsoft
Customer: replied 1 year ago.
(Posted by JustAnswer at customer's request) Hello. I would like to request the following Expert Service(s) from you: Live Phone Call. Let me know if you need more information, or send me the service offer(s) so we can proceed.
Customer: replied 1 year ago.
When i select the file to open i get a message advising that "I'snt an index in this table. look in the indexes collection of the TableDef object to determine the valid index names".
Expert:  WesPCDr replied 1 year ago.
Hi, I can help with the issue.
Expert:  WesPCDr replied 1 year ago.
The file may be corrupted. I can take a look at the file to determine if it is recoverable.Would you be able to send me the file? You can use http://wikisend.com to upload the file and post the link here.Thanks
Customer: replied 1 year ago.
Please find below link to my filehttp://wikisend.com/download/612226/Buses3.mdb
Expert:  WesPCDr replied 1 year ago.
I'm reviewing the file now.
Customer: replied 1 year ago.
Thanks
Expert:  WesPCDr replied 1 year ago.
Was this file created with Access 2013 or 2016?
Customer: replied 1 year ago.
Get ready i think it was 97
Expert:  WesPCDr replied 1 year ago.
With Access 97, the repair tools are not as good. I was unable to import the database using Access 2013.This means the database is corrupt. The only chance is to try to recover using the import method. This is the best article I found since I don't have Access 97. "What eventually worked was to open the corrupted database and manually export each object from the corrupted database to a brand new database. I was able to do this with the export tools in the ribbon bar and by selecting “Access” as my export option. I did have to create the new, blank database first; the database to export all of the data to. "http://www.lmhproductions.com/237/microsoft-access-id-is-not-an-index-in-this-table/
Customer: replied 1 year ago.
I'm afraid I don 't understand what I should do. Can you explain or call me 01563 850132
Expert:  WesPCDr replied 1 year ago.
Follow the steps in this link in section Steps for trying to repair a damaged database https://support.microsoft.com/en-us/kb/283849