Forum Discussion
Query UPDATE crash on all MS Access x64 after the November 12th patch
cgentile If you can uninstall just go ahead and uninstall it...if not you have to "replace" your tables with queries
For example you have a Table named myTable and normally
UPDATE myTable SET SomeField = SomeValue
Now either
UPDATE (SELECT * FROM myTable) SET SomeField = SomeValue
or
rename myTable to e.g. myTable_tbl and create a query name myTable with SQL : SELECT * FROM myTable_tbl
so
UPDATE myTable SET SomeField = SomeValue '(here mytable is the query that "replaces" the original myTable)
- WalkerBoh72Nov 18, 2019Copper Contributor
tsgiannis this workaround works, however it's har to follow this path, having dozens of queries and VBA command, and some modules not directly accessible by myself, being protected by the software house who developed our ERP
- cgentileNov 18, 2019Copper Contributor
STATUS: FIXED
This issue will be fixed for all versions:
Version BuildRelease Date
Access 2010
7242.5000
December 10, 2019
Access 2013
5197.1000
December 10, 2019
Access 2016 MSI
4939.1000
December 10, 2019
Access 2019 Volume License
10352.20054
December 10, 2019
Access for Office 365/Access 2019 (Version 1911)
12228.20152
November 24, 2019 (estimated)
https://support.office.com/en-us/article/access-error-query-is-corrupt-fad205a5-9fd4-49f1-be83-f21636caedec
- WalkerBoh72Nov 18, 2019Copper Contributor
cgentile I hope this issue can be pushed for way faster fix. We can't afford to have our application stopped for a moth.