Can anybody suggest me a way to repair my mdb file. I have some important information in that file. I am using MS office 2007.
You suggestion will be appreciated.
Lookup the RepairDatabase function in online help. This is a member function of
the CDaoWorkspace class or if your using the DAOSDK a member function of the
CdbDBEngine class.
Onine you can also get a lot of software to repair mdb files like
You need a Access database recovery software that accurately recovers all the corrupted MDB and ACCDB database files and restore you data in working condition. For more information visit here:
http://www.repairaccess.net/
Hmm Aishwarya
I think you lost your crucial access database. Don't worry dear your query is not tough as you are thinking. In such situation You can use an Access File Recovery tool which are available in market arena and helps you in getting accuarte solution of your queries how to repair MDB files.
Otherwise you can see the following article this will help you in accurate format
http://gallery.technet.microsoft.com/Access-Database-Repair-The-c307863b
By reading this article you will definetly get the solution of your query.
Dear Aishwarya.r, you can Compact and Repair your corrupt .mdb file. But, are you sure that the file database file is with .mdb extension or is it .accdb file? As you are using MS Office 2007, the database file should be .accdb intead of .mdb. Maybe you have done some changes while saving the file. You should use Compact and Repair to repair the file.
To Compact and Repair your database file in MS Access 2007:
1. Click on Office button (on top side of the left corner).
2. From the Menu, click on Manage > Compact and Repair Database.
3. Now select the database file that you want to repair.
Within a few seconds the file will be repaired, if possible. If it fails to repair the file, then you can use a third-party access recovery software. I have used such a software in my past named as sysinfotools ms access recovery. It repaired my corrupt .accdb files without taking my much time. I suggest you to check its free demo before going for any other third-party application. Read more about this software and download its free demo from the link shown above.