Monday, November 23, 2009

Data Types inaccessible in ACCDB File

Microsoft Access database provides multiple choice of data types that enable you to store the different form of information in table fields. The mapping of all the data types to manage various database options is taken care by ACCDB applications programming interface. Few most commonly used data types are text, boolean, integer, decimal, time, and float. All these data types can become inaccessible in case your ACCDB file gets corrupted or damaged. In such situations, an ideal way is always to restore your database from an updated backup. But, in case of backup inaccessibility or backup itself getting corrupted, you need to search for advance third-party repair access application that can repair your database.

As a practical instance, when you attempt to view the data types assigned to different fields of a database table, some the fields seem to be empty or inaccessible.

Cause:

The main cause for data types not being displayed is the corruption or damage in ACCDB file. Few main causes for the file corruption are application malfunction, improper system shutdown, virus attack, and human errors.

How to Resolve:

To orderly repair your ACCDB file after corruption, you will need to Compact and repair the database using the below steps:
1.To begin, select “Database Utilities” option under the Tools menu list.
2.Next, select “Compact and Repair Database”.
3.Select the corrupt ACCDB file in the “Database to Compact From” dialog box. Click on Compact.
4.Store the new ACCDB file in a new folder destination by selecting the “Compact Database Into” dialog box.
5.Provide a new to ACCDB file.
6.Click on “Save”.

In most cases, the inbuilt repair utility repairs your database and allows you to view data types. But if in case, the database repair utility fails to repair the database, then you will need to use en effective access database repair utility that can repair your database and recover all the data types applied on table in ACCDB file. These Access Repair ensure complete repair of database after any degree of corruption.

No comments:

Post a Comment