title: How to avoid the "Cannot delete from specified tables." in MS Access
body: <p>Here is the code that I am trying to run:</p>
  
  <pre><code>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
    )));
  </code></pre>
  
  <p>Every time I try to run this in Access I get error 3086, "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 (separating schema and table names with <code>.</code> instead of <code>_</code>) in Toad and it worked fine.</p>