bfuchs
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
Getting attached error when trying to perform an update query.
The underlying table is updatable in Access.
Table is SQL based.
Untitled.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
...or for the time being just "replace" the table with a queryDid that and didn't help, see attached.
Thanks,
Ben
Untitled.png
ASKER
Thank you!
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