Query can't Delete records from Linked Table
Posted on 2001-08-15
I have an Access 2000 DB with two tables:
"Products" is a linked table to an Informix Database on another server.
"tblProductsToDelete" is a table in the current database with ProductID's that we want to DELETE from the linked table.
My SQL statement is
FROM Products INNER JOIN tblProductsToDelete ON Products.ID = tblProductsToDelete.ID;
When I run this I get an error:
"Could not Delete from Specified Table"
The HELP file explains that this is a READ-ONLY permissions issue with the linked table.
However, when I execute a more specific DELETE query:
WHERE Products.ID = "123"
This query successfully deletes the specified record from the Linked table.
By adding the Join, the Linked table somehow becomes READ-ONLY.
Do you have a suggestion for overcoming this?