Microsoft Access "Query is corrupt" error when using 'update' command with Database Toolbox
1 view (last 30 days)
Show older comments
MathWorks Support Team
on 14 Nov 2019
Edited: MathWorks Support Team
on 23 Jun 2021
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.
Accepted Answer
MathWorks Support Team
on 23 Jun 2021
Edited: MathWorks Support Team
on 23 Jun 2021
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 Comments
More Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!