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:
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.
采纳的回答
MathWorks Support Team
2021-6-23
编辑：MathWorks Support Team
2021-6-23
0 个投票
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.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息
2019-11-14
2021-6-23
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
