I get an error whenever I try to run an update query.
I have a Linked Table. I want to take the values in this linked table and run an update query to update a different table in the database.
However, whenever I run the query i get an error that says "Operation must use an updateable query". I tried so far as to create a query of these linked values and update the table, but still no such luck. Appending works just fine - but not updating.
Any suggestions? Maybe this is a problem associated with linked tables?
Thanks,