Thursday, August 26, 2010

How to recover and repair Access Database

The popularity of Microsoft Access is due to its widespread availability and also because of its flexible functionality. However, constant modifications to the database often result in data corruption. Advanced Access Repair allows for the easy recovery and repair of damaged or corrupt Access database files.

Microsoft Access is a powerful database management system that can be used for almost all information management needs - an individual may use it to create a simple address list while an organization may use it for their complex inventory management system. This flexibility and widespread use of Access databases also means that they quickly grow in size, at times unnecessarily using up disk space. These databases may also require constant modifications, especially when they are being shared by multiple users, increasing the risk of data files getting corrupted.

When a database becomes damaged, Access typically detects this when you try to open the database, compact it or encrypt it and offers to immediately repair it. There are times, however, when Access does not detect any damage and yet you face problems in working with the database. At such times, the Compact and Repair Database utility in Microsoft Access is a useful tool that helps in not only optimizing but also repairing damaged database files.

Using the Compact and Repair utility is fairly easy and straightforward.
Step 1. Close all databases and request all users to close their databases.
Step 2. Now, from the empty Access window, choose Tools -> Database Utilities -> Compact and Repair Database.
Step 3. You will be presented with the 'Compact Database From' dialog box - select the database you want to compact and repair and click 'Compact'.
Step 4. In the 'Compact Database Into' dialog box, provide a new name for the compacted database and click 'Save'.
Step 5. Once you make sure that the new database is working, delete the old database and rename the new database by the old name.

Occasionally this effort to repair a damaged database fails and one looks for more comprehensive alternatives that will address various error messages as well as recover data. Advanced Access Repair from DataNumen, is a very intuitive and powerful Access recovery tool that provides fast and effective solutions to commonly found errors. Not only that, it attempts to retrieve as much of data as possible from your corrupt and damaged data files, by using advanced technologies. Advanced Access Repair can recover both the structure and records of tables in damaged data files even on corrupted media such as CD-ROMs; it can also recover deleted records and tables. In a great time saving feature, one can repair an entire batch of data files using this recovery tool. Advanced Access Repair is a must have for all those who use Microsoft Access extensively and want to safeguard the integrity of important data.

Article Source :- http://www.ehow.com/how_5613200_recover-repair-access-database.html

  • 2

    Using the Compact and Repair utility is fairly easy and straightforward.
    Step 1. Close all databases and request all users to close their databases.
    Step 2. Now, from the empty Access window, choose Tools -> Database Utilities -> Compact and Repair Database.
    Step 3. You will be presented with the 'Compact Database From' dialog box - select the database you want to compact and repair and click 'Compact'.
    Step 4. In the 'Compact Database Into' dialog box, provide a new name for the compacted database and click 'Save'.
    Step 5. Once you make sure that the new database is working, delete the old database and rename the new database by the old name.

  • 3

    Occasionally this effort to repair a damaged database fails and one looks for more comprehensive alternatives that will address various error messages as well as recover data. Advanced Access Repair from DataNumen, is a very intuitive and powerful Access recovery tool that provides fast and effective solutions to commonly found errors. Not only that, it attempts to retrieve as much of data as possible from your corrupt and damaged data files, by using advanced technologies. Advanced Access Repair can recover both the structure and records of tables in damaged data files even on corrupted media such as CD-ROMs; it can also recover deleted records and tables. In a great time saving feature, one can repair an entire batch of data files using this recovery tool. Advanced Access Repair is a must have for all those who use Microsoft Access extensively and want to safeguard the integrity of important data.

  • Tuesday, August 24, 2010

    How to Fix Unrecognized Database Format Filename Mdb Error in MS Access

    Microsoft Access is a widely-used desktop relational database application. The .mdb files created with this program contain tables, fields, data entry forms, queries, stored procedures, reports, and more. An .mdb file stores data as continuous pages with a fixed size. The first page, database definition page, holds the most important definitions of the database. And, if this page structure gets damaged due to any reason, Access will not be able to recognize and read pages in the file and will report an error. In such situations, it becomes important to repair corrupt.mdb file or access the data from a clean and updated backup. However, if no backup is available, then you must consider using an advanced Access recovery software.

    Consider a practical scenario, wherein, you try and mount an Access database (related to your employees personal details) and receive the following error message:

    Unrecognized database format 'filename.mdb'

    In the above error, the filename.mdb refers to corrupt.mdb file. As a result of the error, you cannot access relevant information related to your employees.

    Cause

    There might be two possible reasons for this particular error:

    1. The error can appear when you are trying to open the Access database in an earlier version instead of opening it in the newer version of MS Access
    2. The error can also appear if your MS Access database is corrupt

    Resolution

    Try the following Access database recovery steps in order to access database information:

    1. You must convert the database into the lower version of MS Access, using your current version. After converting, you can open the database with an older version.
    2. In order to repair the corrupt Access database, you can use the inbuilt repair utility, Compact and Repair. Consider the following steps:
    On the Tools menu, point to Database Utilities, and then click Compact and Repair Database.
    In the Database to Compact From dialog box, specify the Access file you want to compact, and then click Compact.
    In the Compact Database Into dialog box, specify a name, drive, and folder for the compacted Access file.
    Click Save.
    If after observing the above-mentioned steps, you still encounter the same error, download an Access repair software from the Internet.

    Jeny is a self employed Internet entrepreneur and product reviewer. This mdb repair utility is extremely useful when the access file gets corrupted due to internal program errors, hardware malfunctioning and more.

    Article Source: http://EzineArticles.com/?expert=Jeny_Maria