Dealing with Access errors occurred while record updation

Records are updated in tables or forms of .mdb files daily. There are various ways of updating the records in an Access database. Some methods are simple, convenient and effortless while others may need some coding.  For example, updating the record based on a query may not always turn out to be correct.

In a practical scenario, when you try to update a record on a form in an Access database, you may receive the following error messages:

“This Recordset is not updateable”

“Field can’t be updated”

“The field can’t be updated because another user or process has locked the corresponding record or table”

“Operation must use an updatable query”

Microsoft Access shows such errors when the form is based on a query that is not updateable.  Due to these errors, Access database gets corrupted and the data saved in the .mdb files becomes inaccessible. There can be two main causes of this error:

• Updating of records that were the primary keys values
• Violating referential integrity rules for a relationship defined between tables

When it comes to dealing with Microsoft Access corruption issues, first of all you need to try the inbuilt utility (“Compact and Repair“) provided in Microsoft Access. Follow the simple steps for using this utility:

1. On the Tools menu, select Database Utilities and then click “Compact and Repair Database”
2. Locate and then click the database in the ‘Database to Compact From’ dialog box, and then click Compact.
3. Select an appropriate folder location for the new file in the ‘Compact Database Into’ dialog box and then provide a unique name for the file.
4. Click Save button to save the file.

In most of the cases, this inbuilt utility resolves the corruption. However, if after executing these steps, the problem still persists, then you need to opt for powerful and result oriented MS Access repair software. These tools employ highly efficient repair algorithms to completely scan and repair the corrupted database. But make sure that the tool you are using is the powerful and efficient one. So, in order to find an effective tool, you need to analyze the quality of the software’s by executing the free trial version provided by software vendors.

Comments are closed.