title: Cannot join on Memo, OLE, or Hyperlink Object
body: <p>I have a basic table in an Access database.  In that table, I have a 10-digit numeric field that is stored as Long Text (leading zeros are significant).  I extracted the unique values from that field in the table, and created a new table/field with the same Long Text data type.  When I try to join that field back to the original table, I get the error: Cannot join on Memo, OLE, or Hyperlink Object.  Is there a work around for this, or a known problem I need to address?</p>