DAO or Data Access Object is an API or Application Programming Interface available with Microsoft Visual Basic that lets the programmers request access to the Microsoft Access databases. It is the first object oriented interface with database by Microsoft.
Along with creating object oriented applications, DAO is also used for recovering data from damaged Access database tables. You can recover your data using the Microsoft Data Access Objects (DAO) db.Execute method. This method is useful in case if you can’t recover your data using MS query or Compact and Repair database tool in Microsoft Access.
You can recover Access database using DAO method by following these steps:
1. Make a duplicate copy of corrupted data with name Recoverd_Database excluding damaged tables
2. Open the Access database that has corrupted tables
3. Click Modules-> New
4. Write the recovery code in the module that is available on Microsoft’s website
5. In the File menu, click Save
6. In the Run menu, click Run Sub/UserForm
7. Revise steps 3-6 for easy damaged table
After completion, check the resulted database. If it is working fine then delete the damaged database. This method is useful in most of the cases of database corruption. But there are some situations where DAO also can’t repair and restore the corrupted database like MS Query and Compact and Repair tools.
These are very critical situations for an Access user. The general question which arises here- What to do for recovering the database? But there is no need to worry about your data. Your data can be repaired using advanced file repair software. These software are known asAccess repair software for this case.
Access Recovery software are the specially designed application software to repair and restore MDB file. Access recovery software are the easy and quick solution for MDB repair. These software can be used by all kinds of users ranging from professional users to general home users.
Stellar Phoenix Access Recovery software is the best ever made and the fabulous Access repair software. This Access recovery software has several advanced features and great controls to make Access recovery process easy and efficient. Using Stellar Phoenix Access Recovery software, you can repair and restore the corrupted database tables, reports, forms, queries, macros, database relationships, and database constraints.
This outstanding Access recovery software is capable of repairing MDB file from all file versions of Access including 2007, 2003, 2002, 2000 and 97. To check the user interface, powerfulness and usability of this Access recovery software, you can go for its free demo version available on Stellar’s website.
