Saturday, November 21, 2009

MS Access Error Messages during Table Record Updation

Records stored in Access database are subject to change to fulfill all necessary requirements. There are many ways that allow you to update your database, for example, using a query. While updation ensures that your database is always up-to-date, the process gets halted in case your Access database is corrupted or damaged. To overcome such situations and to successfully update your data, you will need to delete the corrupted database and restore the new database from an recent backup. However, there might be a possibility that you have not created any backup or backup is unable to restore the desired content. In such situations, you will need to use advanced access database repair application to repair your database.

As a practical instance, you encounter any of the below error messages when you attempt to update the records stored in the table:

“This Recordset is not updateable”
Or
“Field can’t be updated”
Or
“Operation must use an updatable query”

Updation of the records did not occur after any of the above error messages appear.

Cause:

The above error messages primarily occur when your Access database is corrupted or damaged.

Resolution:

To resolve MS Access database corruption, compact and repair your database following the underneath steps:
Select “Database Utilities” option by clicking on Tools menu.
Next, you will need to click on Compact and Repair Database option.
Select the damaged database (MDB) file in the ‘Database to Compact From’ dialog box that needs to be repaired. Click on Compact.
Select a new location for the new file in the ‘Compact Database Into’ dialog box.
Provide a valid and new name for the repaired database file. Finally, click on Save.

In most circumstances, the repair utility repairs the database and allows you to update the database. However, is the database repair fails and any of the above error message still persists, then you will need to use powerful third-party Access Repair software. These access recovery tools are resolve corruption and make all your Access database objects accessible.

No comments:

Post a Comment