Link to home
Start Free TrialLog in
Avatar of bfuchs
bfuchsFlag for United States of America

asked on

Cannot run update query to linked table.

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
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

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
ASKER CERTIFIED SOLUTION
Avatar of Daniel Pineault
Daniel Pineault

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bfuchs

ASKER

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

Thanks,
Ben
Untitled.png
Avatar of bfuchs

ASKER

Thank you!