{"id":130546,"date":"2023-04-10T08:33:46","date_gmt":"2023-04-10T08:33:46","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=130546"},"modified":"2026-03-02T08:40:22","modified_gmt":"2026-03-02T08:40:22","slug":"fix-access-database-not-updating-issue","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/fix-access-database-not-updating-issue\/","title":{"rendered":"How to Fix Access Database not Updating Issue?"},"content":{"rendered":"
Many users have reported experiencing the “database not updating” error while updating forms, tables, queries, or records in Access database (MDB\/ACCDB) files. It usually occurs when you try to use “update queries” or records through a VBA code in the Access database. Such an error can also appear when you forget to use an updatable query in a code or if you are using a record set that is not updatable. When you try to update or delete data in the database via query, you can receive one of the below error messages:<\/p>
\n
This record set is not updatable.<\/li>\n\n\n\n
Access linked table not updating.<\/li>\n\n\n\n
The operation must use an updatable query.<\/li>\n\n\n\n
Updating data in a linked table is not supported by this ISAM.<\/li>\n<\/ul>
Common Error Messages Related to Access Database Not Updating Issue<\/strong><\/h2>
You may fail to modify the data in the Access database files due to many reasons. A few of them are cited below:<\/p>
\n
You cannot update the query directly if it involves multiple tables or if there are many-to-one, many-to-many relationships.<\/li>\n\n\n\n
If you trying to update a crosstab query (such a query is used to present the large information in compact form).<\/li>\n\n\n\n
If the queries in an Access file are corrupted or damaged.<\/li>\n\n\n\n
If the table in which you are trying to use the update query is corrupted.<\/li>\n\n\n\n
When the query is a union query or its unique value property is set to Yes.<\/li>\n\n\n\n
If the query contains a linked ODBC table without a primary key.<\/li>\n\n\n\n
When you are not permitted to update data in a query.<\/li>\n\n\n\n
When there are multiple tables in a query and you forgot to join the tables.<\/li>\n\n\n\n
If you’re trying to update the calculated field.<\/li>\n\n\n\n
When you are trying to update a read-only database.<\/li>\n\n\n\n
When you are attempting to update the locked records.<\/li>\n<\/ul>
Methods to Fix the “Access Database Not Updating” Issue<\/strong><\/h2>
You can follow the below-mentioned methods to resolve the unable to update the database issue in MS Access.<\/p>
Method 1: Enable “Cascading Updates Related Fields”<\/strong><\/h3>
You can get the ‘unable to update query’ error if your query involves multiple types of table relationships. In such a case, you can use cascade update tool in Access. It has various options to ensure the validity of the data, such as “Cascade Update Related Fields”<\/strong>. You can try enabling Cascade Updates Related Fields option to fix the Access database not updating issue. To enable this option, follow these steps:<\/p>
\n
Open the Access database.<\/li>\n\n\n\n
Go to Database Tools<\/strong> and then click Relationships.<\/strong><\/li>\n<\/ul><\/figure>
\n
Double-click on the line between two tables.<\/li>\n\n\n\n
The Edit Relationships<\/strong> window is displayed.<\/li>\n<\/ul><\/figure>
\n
Select the checkbox named “Cascade Update Related Fields”.<\/strong><\/li>\n\n\n\n
Click OK<\/strong>.<\/li>\n\n\n\n
Now close the Relationships<\/strong> window.<\/li>\n<\/ul>
Method 2: Check the Record-Locks Property of the Forms<\/strong><\/h3>
Sometimes, Access Database fails to update due to record-locks settings. This setting can prevent you from updating the same record at the same time. So, ensure that you set the record-locks property correctly. To check these settings, follow these steps:<\/p>
\n
Go to the Microsoft Office <\/strong>button.<\/li>\n\n\n\n
Select Access Options<\/strong>.<\/li>\n\n\n\n
In the Access Options<\/strong> wizard, click on the Advanced <\/strong>button.<\/li>\n\n\n\n
Select on the option you need, under the Default record-locking<\/strong> section.<\/li>\n<\/ul>
Method 3: Change the Properties of Database<\/strong><\/h3>
You may get the “Access database not updating” issue if you are trying to update the data in a read-only database. In such a case, you can change the read-only attribute. Here are the steps:<\/p>
\n
Open File Explorer <\/strong>on your system.<\/strong><\/li>\n\n\n\n
Search the Microsoft Access database<\/strong> that you need to move.<\/li>\n\n\n\n
Right-click on the database <\/strong>and then choose Properties<\/strong>.<\/li>\n\n\n\n
In the Properties <\/strong>dialog box, under the Attributes<\/strong> section, unselect the Read-only<\/strong> checkbox.<\/li>\n\n\n\n
To apply the changes, click the OK <\/strong>button.<\/li>\n\n\n\n
Now check if you are able to update the database.<\/li>\n<\/ul>
Method 4: Check the Allow Edits Property<\/strong><\/h3>
You may encounter the “Access database not updating” issue while editing a form in the Access database. Access has an ‘AllowEdits property’ to specify whether you are allowed to edit the saved records in a form or not. You can check the property using the below steps:<\/p>
\n
Open the Access database.<\/li>\n\n\n\n
Open the form (where you are getting the error) in the design mode.<\/li>\n\n\n\n
Right-click on the form and select Form Properties.<\/li>\n<\/ul><\/figure>
\n
In the Property Sheet dialog box, click Data and then change the option to Yes against Allow Edits.\n
\n
\n<\/li><\/ul>\n<\/li>\n<\/ul>
\n
Save the changes and close the window.<\/li>\n<\/ul>
Method 5: Check the Validation Rule in the Property Sheet<\/strong><\/h3>
The Access database not updating error can occur if there are defined validation rules in the form. The validation rules are used for controls in the form and table. You can check for the validation rules in a form in the database using the below steps:<\/p>
\n
Open the form in the design mode.<\/li>\n\n\n\n
Click on the Properties button.<\/li>\n<\/ul><\/figure>
\n
Click Data and then Validation Rule.<\/li>\n\n\n\n
Check if any Validation Rule has been set.<\/li>\n\n\n\n
Do the changes (if required) and then save the applied changes.<\/li>\n<\/ul>
Method 6: Repair the Access Database<\/strong><\/h3>
Sometimes, corruption in database file can prevent you from updating the data in it. In such a case, you can use the Compact and Repair tool in MS Access to repair corrupted Access database files. To use this tool, follow the steps given below:<\/p>
\n
Open the desired Access database.<\/li>\n\n\n\n
Go to the File <\/strong>menu.<\/li>\n\n\n\n
Go to the Info tab <\/strong>and then click on Compact & Repair Database<\/strong>.<\/li>\n<\/ul>
Microsoft Access will create a copy of the repaired database at the same location where your database is stored.<\/p>
![\"Relationships](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/04\/relationships-option-in-access.png\")
<\/figure>![\"Edit](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/04\/edit-relationships-window.png\")
<\/figure>![\"Form](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/04\/form-properties-option.png\")
<\/figure>![\"Select](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/04\/select-properties-on-form-1.png\")
<\/figure>