Monday, May 7, 2012

Access Recovery Using MS Query to Fix Damaged Database Tables

Microsoft Office includes an excellent tool, known as MS Query, to help you import data to MS Office applications from the external sources. This tool is particularly helpful for Microsoft Access to bring data to Access tables from external sources and databases. The advanced utility helps you perform Access database recovery in certain situations. Process of retrieving corrupted tables and other database objects using MS Query is described in this article.

You should keep the following two things in mind before starting the Access repair process using MS Query:
  • Do not forget to test the recovered database, prior to return it in production environment.
  • Never remove the damaged or corrupted Access database, until you confirm that recover is successful.
Following steps describe the Access database repair process using MS Query tool:
  • Create a duplicate copy of corrupted database and start Microsoft Excel.
  • In new Excel workbook, click Data option, and then point to Get External Data. Click New Database Query.
  • Click New Data Source in dialog box of Choose Data Source and click OK.
  • Name the data source with TestRecover in first step of Create New Data Source.
  • Select Access driver or .MDB in second step and then click Connect.
  • Click Select in dialog box of ODBC Microsoft Access Setup.
  • Browse the corrupted database in Select Database screen and click OK.
  • Click OK on Create New Data Source screen.
  • Select TestRecovery in Choose Data Source screen and click OK.
  • Double-click first table on Query Wizard- Choose Columns screen to add files to Columns in your query.
  • Follow the on screen instructions to finish the process.
  • Save data to Excel spreadsheet when it prompts and repeat these steps for all the tables.
  • Import all the spreadsheets to a separate spreadsheet.
After exporting all the data, you can now import data from spreadsheets to new database. The above mentioned steps work in most of the database corruption scenarios.
In case you are not able to work around the problem using above solution, you can opt for third-party recovery solutions. Such tools are designed particularly to repair and restore all damaged database objects in all cases of corruption.

Thursday, June 16, 2011

Access Database Recovery to Fix Corruption After Interrupted Update

Microsoft Access database is made up of numerous objects, which include reports, tables, stored procedures, triggers, and views. Table is the most significant object of any Microsoft Database (MDB) file. It stores all your records in the form of rows and columns, to provide easy and quick access. You can quickly update the table records on a regular basis, as per your requirements. However, sometimes you may face problem while updating the database and may encounter various corruption errors. This behavior leads to data loss and put you in need of Access recovery solutions.

The database updates operations in Microsoft Access include modify, delete, and add information to/from database. The update process must complete successfully to ensure best results. Any kind of interruption in the update process may leave your database in corrupt state and make all the stored database inaccessible. Database corruption is the worst scenario for an Access user and it requires Access repair to be resolved.

MS Access database corruption is usually identified by a number of odd symptoms, which include strange behavior of the application and error messages while working on it. For example, you may encounter either of the following error messages while accessing records from MDB file after a failed update process:

• Jet has stopped the process because you and another user attempted to change the same data at the same time.
• #Error


Microsoft Access may produce the above errors in following two situations:

• Other users are concurrently trying to update the same database table using any of the update commands- delete, add, or modify.
• The database is too damaged to be identified by Microsoft Access relational database management system.


Nevertheless of the root of this problem, you need to perform Access recovery to restore data from unusable database in such cases. You can try any of the following solutions for this:

• Make sure that no other user is updating the database simultaneously.
• Use Compact and Repair utility to fix database inconsistency issues.
• Restore database from current backup.
• Use commercial Access repair software to extract inaccessible data from the database.

Third-party applications are effective in all cases of corruption, no matter what is the extent and cause of damage. They restore all database objects, including reports, tables, views, stored procedures, constraints, and data types. Such tools are available for Microsoft Access 2010, 2007, 2003, 2002, and 2000.

Thursday, May 19, 2011

Access Database Recovery When JETCOMP.exe Fails to Compact Database

In today’s computer world, database is one of the most efficient ways to store your precious data. Relational Database Management System (RDBMS) offers easy and fast accessing of data. It also lets you share the data over network. Microsoft Access is a very common and widely used RDBMS for small businesses. However, there are some situations, where you may face JET Compact Utility (JETCOMP.exe) corruption in Access and run across data loss. In such critical situations, you need to opt for Access recovery solutions to get your precious data back.

JETCOMP.exe is an inbuilt utility of Microsoft Access that helps you compact and repair database. The tool allows you to compact the large Microsoft Database (MDB) file and fixes corruption for Microsoft JET Database Engine 4.x and 3.x. However, there are some conditions where this tool fails to compact and repair Access database.

As a real-life example of this problem with Microsoft Access database, you may run across the below error message when you try to compact the MDB file:

“Records can't be read, no read permissions on MyDatabase.”

After the above error message, the compact process fails and the database remains inaccessible. At this point, you have to find out the root cause of this problem and then fix it using Access database recovery solutions.


The compact process fails usually if the database is very badly corrupted. Corruption can be the outcome of virus infection, application malfunction, accidental system shutdown, and more. When it happens, Access can not read the database and thus it can not be compacted.


Try either of the following Access recovery solutions to work around this problem:
• Restore your significant data from the most updated backup. In order to ensure perfect recovery, the backup must be valid and current.
• If backup is not usable, repair and restore corrupt database using commercial Access database recovery tools.

Third-party applications are powerful enough to effectively scan entire database using advanced scanning techniques. They preserve absolute integrity of your valuable data with read-only nature. Such applications properly handles virtually every database corruption issue for Microsoft Access 2010, 2007, 2003, 2002 (XP), and 2000.

Sunday, May 8, 2011

Access Recovery to Handle Internal Process Error in Microsoft Access

Microsoft Access is an integral part of Microsoft Windows operating system based computer. It is an advanced and effective Relational Database Management System (RDBMS), which is part of Microsoft Office Suite of Applications. However, under some critical situations, you may not start the Access database properly. In such cases, Master Database File (MDB File) becomes inaccessible. It leads to critical data loss situations and put you in need of Access recovery solutions.

In order to extract data from Microsoft Access database, you must first mount it. Access database is automatically mounted when you start it. However, if database can not be started when you start MS Access, all the objects of MDB file become totally inaccessible. This behavior leads to severe data loss situations.

As an example of this critical problem with Microsoft Access, you may encounter the following error message while mounting Access database:

“An internal processing error has occurred. Try restarting the Exchange System Manager or the Microsoft Exchange Information Store service, or both. ID no: c1041724”

The database can not be mounted in such situations. It makes your access database totally unusable and irresponsive. To repair Access data in such situations, you need to identify the root of this problem and fix it using Access repair solutions.


You may face this problem due to any of the following reasons:

• The Temp folder is not accessible.
• Database permissions are set incorrectly.
• Database is corrupted and Access is unable to recognize it.


Try any of the following Access recovery methods to work around this problem:

• Make sure that Temp folder is there on the drive and accessible.
• Make sure you have proper permissions to access the database.
• Restore database from the most recent backup.
• Repair Access database objects using third-party Access recovery tools.

The commercial applications are powerful enough to perform in-depth scan of entire database to extract all database objects. They are totally safe and easy to use with read-only nature and interactive user interface. Such tools successfully repairs and restores data from Access 2010, 2007, 2003, 2002 (XP), and 2000.

Tuesday, April 12, 2011

Access Repair to Fix Database Corruption While Converting MDB File Using DAO

Microsoft Access is one of the most popular and widely used Relational Database Management System (RDBMS) for small business and home users. It enables multi-user access and supports several other features. However, Microsoft recommends not performing too much concurrent operations on the MDB (Microsoft Database) file. It increases the chances of database corruption and data loss problems. In case of corruption you need to opt for Access database repair solutions.

When corruption occurs to the Access database, you get a number of error messages and face strange behavior of the application. For instance, you may encounter the below error message when you try to open an Access database-

“This database has been converted from a prior version of Microsoft Office Access by using the DAO Compact Database method instead of the Convert Database command on the Tools menu (Database Utilities submenu). This has left the database in a partially converted state. If you have a copy of the database in its original format, use the onvertg Database command on the Tools menu (Database Utilities submenu) to onvert. If the original database is no longer available, create a new database and import your tables and queries to preserve your data. Your other database objects can't be recovered.”

After the above error message, the MDB file becomes inaccessible. In order to repair Access database in such situations, you need to opt for Access repair solutions after finding the actual cause of the issue.


The problem occurs after using the Data Access Objects (DAO) for converting Access database of previous version through Compact Database procedure. Any problem with this database may cause corruption and database becomes totally unusable.


The most efficient repair Access solution to handle such situations is to restore the damaged Access database from the most recent backup. In order to ensure absolute Access database recovery, you must have an updated and valid backup.

If you do not have current backup in place, the only solution is to use Access repair software. The third party Access database repair tools are designed to scan entire database through advanced scanning techniques. They offer easy and safe recovery in all cases of Access database corruption.

Tuesday, April 5, 2011

Access Database Recovery When Migration to MySQL Database Fails

Microsoft Access, a part of Microsoft Office Suite of Product, is the ideal database management system for small businesses. It is easy to manage and offers a number of advanced features. However, in some cases, you may want to migrate your Access database to MySQL, if the available features cannot fulfill the requirements. You must follow all the migration steps carefully to prevent errors and database corruption that ultimately needs Access repair solutions.

Database migration from Access to MySQL undoubtedly offers a wide range of benefits. These efficient features include advanced database security, multi-user access over network, high-performance, and cross platform compatibility. Sometimes, the migration process may fail with some errors and database become unusable. Such issues may occur due to partial or complete corruption to the MS Access database.

The most efficient way to prevent such situations is to create a complete backup of entire Access database. Backup can also be used to perform Access database repair in case of corruption. You must always backup the Access database to a reliable storage media in order to ensure absolute Access recovery.

As a real-life example of this problem with MS Access database you may find that the application is unable to recognize the MDB (Master Database) file. When you export the database to MySQL, it cannot be accessed even in MySQL.

Root of the problem-

The most common reason of the database inaccessibility is the incomplete or failed process of migration. Access database corruption may take place due to any of the below reasons-

  • Low data quality
  • Design or logic errors in reports and forms
  • Damaged JET database engine
  • Poor schema design

How to repair Access database-

Use any of the below Access database repair solutions to work around this problem-

  • Use Compact and Repair tool to fix the corruption. It is an in-built tool to Microsoft Access.
  • Restore the affected database from the most recent backup.

When both the above Access repair methods fail to recover Access database, you need to opt for third-party Access recovery software. They are useful in all cases of corruption, nevertheless the root of the problem. There are numerous application available in the market that can help you recover inaccessible database in such cases, but Stellar Phoenix Access recovery is the most comprehensive one among them.

Thursday, March 17, 2011

Access Recovery to Fix Visual Basic for Applications (VBA) Corruption

VBA or Visual Basic for Applications is an implementation of event drive programming language of Microsoft. It is also an IDE (Integrated Development Environment) that is built in most of the MS Office applications, including Microsoft Access. However, in some situations, VBA may get damaged and cause database corruption. This behavior of MS Access may lead to database inaccessible and cause severe data loss. In such critical situations, you are required to opt for Access database repair solutions to get your mission critical data back.

As a practical example of this problem with Microsoft Access, you may encounter any of the below error message when you attempt to open Visual Basic Editor in MS Access:

The Visual Basic for Applications project in this database is corrupt.


The module name 'module name' is misspelled or refers to a module that doesn't exist.

If the invalid module name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro window, and type the correct module name.

When you encounter this problem, Access database becomes totally inaccessible and you can not even edit the VBA. In such situations, you need to find out the cause of this issue and use Access repair solutions to fix it.


This issue occurs due to corruption to the Visual Basic for Applications (VBA). Corruption can be due to any of the following reasons-

· Virus infection

· Application malfunction

· Storing Access database on network

· Improper system shutdown


Modules, reports, and forms use VBA. You can use the below Access recovery steps to save your queries, macros, and tables-

· Create a blank database.

· Open affected database and click Tables under Objects.

· Right-click first table and click Export on shortcut menu.

· In Export to dialog box, select the newly created database.

· Click new database and click OK.

· Repeat 4 through 6 steps for every table, macro, and query.

If you can not fix this problem using the above steps, then you need to opt for Access repair software. The Access database repair applications are capable of recovering Access database in all corruption situations.

Access recovery software can easily repair all sizes of databases. They work well with Microsoft Access 2010, 2007, 2003, 2002, and 2000. The most efficient and popular Access repair tool is Stellar Phoenix Access Recovery software.