FROM EP3Seq_Deleted INNER JOIN EP3_ShotType_Prcnt ON EP3Seq_Deleted.ID = EP3_ShotType_Prcnt.ID;
gives out this error: "Cannot delete from specified tables". Help explains this as to the tables having read only attributes. However, various append queries work fine with my EP3_ShotType_Prcnt table, and I can delete records manually.
This query updates the table from which I am trying to delete, and it works just fine:
RIGHT JOIN EP3Seq_EP2_AsscUpdate ON EP3_ShotType_Prcnt.EP3Seq_Name = EP3Seq_EP2_AsscUpdate.EP3Seq_Name
SET EP3_ShotType_Prcnt.Sequence = [EP3Seq_EP2_AsscUpdate]![Sequence]
WHERE (((IIf([EP3Seq_EP2_AsscUpdate]![Sequence]=[EP3_ShotType_Prcnt]![Sequence],"No update","Update"))="update"));
Another symptome is that when running this DELETE query as SELECT it gives the correct row that should be deleted.
has any one encountered anything like this before, and are there any solutions?