Cannot join on memo, OLE or Hyperlink Object

  • Thread starter Thread starter Steve Marsh
  • Start date Start date
S

Steve Marsh

Join query against two linked SQL tables returning the
error "Cannot join on memo, OLE or Hyperlink Objects".
None of the columns in either table are memo or hyperlink.

Any comments regarding what might be the source of the
problem would be greatly appreciated.

Steve Marsh
 
Hi,

That just that, a memo or a large binary object cannot be used in a
join, or as a group, or as distinct, it is by design.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top