title: Access error "Cannot join on memo, OLE or hyper link objects", even after changing the data type of the fields relevant fields
body: <p>Originally I was trying to join long text and hyperlink, along with short text etc. The join works when the fields are removed from the query. But after changing the fields (long text to short text &amp; hyperlink to short text) and reintroducing in the query, the query still gives the same error.</p>
  
  <pre><code>SELECT products1.*
  
  FROM products1
      LEFT JOIN Products 
          ON (products1.Category = Products.Category)
          AND (products1.[Minimum Reorder Quantity] = Products.[Minimum Reorder Quantity]) 
          AND (products1.Discontinued = Products.Discontinued) 
          AND (products1.[Quantity Per Unit] = Products.[Quantity Per Unit]) 
          AND (products1.[Target Level] = Products.[Target Level]) 
          AND (products1.[Reorder Level] = Products.[Reorder Level]) 
          AND (products1.[List Price] = Products.[List Price]) 
          AND (products1.[Standard Cost] = Products.[Standard Cost]) 
          AND (products1.ID = Products.ID) AND (products1.[Product Name] = Products.[Product Name]) 
          AND (products1.[Product Code] = Products.[Product Code])
  
  WHERE (
      ((Products.ID) Is Null) 
      AND ((Products.[Product Code]) Is Null)  
      AND ((Products.[Product Name]) Is Null) 
      AND ((Products.[Standard Cost]) Is Null) 
      AND ((Products.[List Price]) Is Null) 
      AND ((Products.[Reorder Level]) Is Null) 
      AND ((Products.[Target Level]) Is Null) 
      AND ((Products.[Quantity Per Unit]) Is Null) 
      AND ((Products.Discontinued) Is Null) 
      AND ((Products.[Minimum Reorder Quantity]) Is Null) 
      AND ((Products.Category) Is Null)
  );
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/aboX4.png" rel="nofollow noreferrer">Link directs to Image showing Table structure</a></p>