Monday, March 26, 2012

Recovery of calculated data type in access database 2010

The previous Access database versions don't have feature to store calculated values. Now in Access 2010 there is a new feature is added that is calculated data type. With the Calculated data type, you can store a formula or expression that is automatically updated when the components of the expression change. So there is no need for the user to ensure that the value is updated or not. But you should use this feature very carefully because in many cases the calculated data types show bad results. This is mostly happen in two cases:

Case I: If you change the formula or Expression after data has been entered into the table. In this case, the existing results may not be updated correctly & it shows bad results.

Case II: Calculated data types can become inaccessible or shows bad results in case your MDB file gets corrupted.

In first case, compact/repair does not recalculate, so in this case, no obvious way is available to repair the bad results.

In second case, you can recover inaccessible calculated data types by using compact/repair utility. In many cases, such as severe corruption, huge database, access database is not opening, compact/repair get failed to recover corrupt calculated data types. Stellar Phoenix Access Database Recovery Software is recovery software that works great with any corruption errors and all updated versions of access database such as access database 2010, 2007, 2003, 2002 etc. The Access Database Repair software comes with advanced recovery options and other advanced features you're simply not going to find in any other software. It's everything you're looking for in access database recovery software.

No comments:

Post a Comment