You can specify the records to modify by applying a filter (WHERE clause) and linking the table to other tables and queries. Update Queries let you modify the values of a field or fields in a table. Once you know why the query won't update, you can rethink the query's structure to obtain a more flexible query. Update Query Option when Designing Queries in MS Access 2007/2010. I think the new issue is not directly related to the original issue: type conversion failure in your original post, it would be better if you open up a new thread for the new question.
The option of 'Use the Cache format that is compatible with MS ACCESS 2010 or later' is checked and additional two checkboxes under this options are also checked. We need to do a query update to clean up some of the column data. Any query that uses an aggregate function (SUM(), MAX(), COUNT(), and so on) in the SELECT clause. We have a list of approximately 6700 items in a SharePoint 2016 site.The first step is to figure out why the query isn't updateable. When this happens, your only choice is to rethink the query's structure. When you try to update a value via a query, Access tells you that the query isn't "updateable." That's not a bug at work Access is working exactly as it should. One of the most frequent questions I receive is about queries that won't update data.