How to avoid the "Cannot delete from specified tables." in MS Access
===

Here is the code that I am trying to run:

    DELETE DISTINCTROW JHALL_REFERAL_ASSIGNMENTS.emp_id, JHALL_REFERAL_ASSIGNMENTS.ref_elem_id
    FROM JHALL_REFERAL_ASSIGNMENTS
    WHERE (((JHALL_REFERAL_ASSIGNMENTS.emp_id)=(select  b.emp_id from JHALL_REFERAL_ELEMENT a, JHALL_REFERAL_ASSIGNMENTS b, BSI_MARTS_D_EMPLOYEE c
        where C.FULL_NM = 'Employee'
        and A.REF_NAME ='Max Premium of 5,000'
        and A.REF_ELEM_ID = B.REF_ELEM_ID
        and B.emp_id = C.EMPLOYEE_KEY
    )) AND ((JHALL_REFERAL_ASSIGNMENTS.ref_elem_id)=(select  a.ref_elem_id from   JHALL_REFERAL_ELEMENT a, JHALL_REFERAL_ASSIGNMENTS b, BSI_MARTS_D_EMPLOYEE c
        where C.FULL_NM = 'Employee'
        and A.REF_NAME ='Max Premium of 5,000'
        and A.REF_ELEM_ID = B.REF_ELEM_ID
        and B.emp_id = C.EMPLOYEE_KEY
      )));

Every time I try to run this in Access I get error "Cannot delete from specified tables." When trying to find information online I keep running into resolutions saying I should change the Unique Records field to "Yes" which I did but that did not solve my issue. I ran the same code(With separating schema and table names with '.' instead of '_') in Toad and it worked fine. Any ideas would be greatly appreciated. 