Cannot run update query to linked table.

bfuchs
bfuchs used Ask the Experts™
on
Hi Experts,

Getting attached error when trying to perform an update query.
The underlying table is updatable in Access.
Table is SQL based.
Untitled.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Commented:
Known problem ...there is a security Update that caused havoc
If you have Access 2016 there is a fix ...or for the time being just "replace" the table with a query
For example
rename table
SVN_printed_history
to
SVN_printed_history_tbl
and create a query
SVN_printed_history
SELECT * from SVN_printed_history_tbl
President / Owner CARDA Consultants Inc.
Distinguished Expert 2018
Commented:
Well, this is but the latest bug caused by a series of flawed security updates that were released November 12th:

Access 2010 – KB4484127
Access 2013 – KB4484119
Access 2016+ – KB4484113
Access 2016+ – KB3085368

I asked the Access Dev Team and was assured that these are the only updates causing this issue.

You can read about the entire blunder by reviewing

https://www.devhut.net/2019/11/14/access-bug-error-3340-query-is-corrupt/

The article includes various workaround and fixes (for certain versions of Access).

The good news is that if you are running Access 2016, 2019 or Access 365, fixes are now available you need only update.

File -> Account -> Update Options -> Update Now

The bad news is that if you are running 2010 or 2013 you are stuck with one of three options:

...or for the time being just "replace" the table with a query
Did that and didn't help, see attached.

Thanks,
Ben
Untitled.png
Thank you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial