Microsoft Access "Query is corrupt" error when using 'update' command with Database Toolbox

Microsoft released an update for Access that introduced an issue with updating tables on Nov. 12.

The following article describes the issue and a workaround:

https://support.microsoft.com/en-us/topic/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec?ui=en-us&rs=en-us&ad=us

The workaround is to basically update the tables indirectly; however, this requires modifying the original SQL statement.

Many users may find an issue with this as it can require an intractable number of changes in their code base.

Answer 1

[MathWorks Support Team]

There is no fix that involves not modifying the call to the 'update' command. The crux of the issue is that the WHERE clause is passed in as a string, so in order to apply the workaround suggested by Microsoft, the new 'update' command would have to parse the WHERE clause and make the appropriate modifications. Since the WHERE clause could be anything, this is not feasible.

For now, until the fix is rolled out by Microsoft, the user will have to apply the workaround from Microsoft by modifying their code interfacing with their database.