I am trying to use a linked table, .csv format to provide data to update another table in my database. When I attempt to run the update query, I get an error message "Updating data in a linked table is not supported by this ISAM." This puzzles me as it's not the linked table I'm trying to update.
Aspects of my database query that may be relevant to my question:
1. There is nothing in the source (linked) table that can be used as a join key, so the query uses two or more fields from the CSV table, via calculated fields in the criteria statements - there are no relationships defined explicitly with join lines between tables, either in the Query design itself or in the Relationships view.
2. I can successfully select the subset of the records in the target table with this query, I just can't update them.
3. I need to use a linked table as these data change each week, are exported from a non-Microsoft application, and I feel it is tedious to import the table each time.
Thanks in advance