Cannot run update query to linked table.

bfuchs used Ask the Experts™
Hi Experts,

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

Do more with

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

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
and create a query
SELECT * from SVN_printed_history_tbl
President / Owner CARDA Consultants Inc.
Distinguished Expert 2018
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

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.

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